Dynamic Input: Using dummy input file for source template. Errors when run on server

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.

Developer Tools

Error Message

Server

Accepted answers

DavidP

The attached workflow is not dissimilar to your workflow, but instead of using a dynamic input, it uses the same batch macro twice, first to read the list of sheet names and then to load the sheets

Batch macro to read multiple sheets from excel file.yxzp

All comments

DavidP

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.

lowellsinghGP

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703