I am using a dummy input data source template and it runs in desktop but when I try and run it in server it errors out saying it can't find the dummy file. I am using the dynamic input to generate the sheet names to add to the file path and later open those individual sheets with another embedded macro.
Solved! Go to Solution.
I think dynamic input has to be able to see the template file.
Another way to do it is to create a batch macro with an Input data tool instead, with a control parameter and action tool to update the fullpath of the file you want to load.
I think this should work on server.
Thanks DavidP
When you mean update the full path how does it recognize the sheet name? I am using dynamic input to pull the sheet names then I add that to the full path witch then gets fed into another macro that opens each sheet in an excel document.
Just add the sheet name to the full path like this
...\foldername\filename.xlsx|||sheetname$
I’ll send you an example shortly.
Thanks DavidP
I am going to hardcode the sheet names into the formula tool since they will never change. However, this is great for dynamic files where sheet names are not consistent. I will use this approach for other workflows for sure.