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.
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.
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.
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.