This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Use the directory tool in conjunction with the attached macro. This will loop through and load in each sheet at a time. This is very useful as it circumvents a problem you often encounter with the standard Directory input with the Dynamic Input tool, where things such as merged cells in Excel often cause problems.
download the attached macro and save it into your macro folder (if you have not set one yet go to Options->User Settings->Edit User Settings and click the "Macros" tab. Click the + sign and navigate to a folder you want to use for your macros.
Once you have done this, use the directory tool to select the parent folder of where your Excel sheets are sitting (using the "Include SubDirectories" option if they are in multiple folders. Then feed this into both macro inputs. In the macro, on the "Questions" tab, select the fullpath field.