Dynamic Input Tool Error: Unable to open archive for unzipping

[Adityasa]

Hi,

I am trying to use the Dynamic Input tool to input data source template. The file that I am using here is inside a shared folder, and I am getting the following issue on running the workflow (refer attached image). Is there any way to reference a file in a shared folder, as we can't use any file in our local system?

PS: In case attached PDF doesn't open, this is what the error in the Dynamic Input tool says: 'Unable to open archive for unzipping: <Location of the shared folder>'

[pedrodrfaria]

Hi @Adityasa 

You did not attached the image you mentioned. Here are a couple of questions to understand the situation:

Are you able to open this file using a regular data input?

Is the file encrypted?

What is the file extension?

We can use a batch macro to open these files instead of the dynamic input, it would be a much easier solution.

Pedro.

[Adityasa]

Hi @pedrodrfaria,

I have attached the image now. Apologies for that.

To your questions:

Are you able to open this file using a regular data input? Yes

Is the file encrypted? No

What is the file extension? .XLSX

Can you help me with the batch macro process?

[pedrodrfaria · Accepted solution]

I attached a macro, use this macro to open it.

Pedro.