Batch macro error message - no sheet specified

[michaelcjoyce]

I am using a batch macro to import data from multiple Excel documents, but am getting the following error message:

 

And yet I am specifying a sheet:

 

Guidance is appreciated.

[Qiu]

@michaelcjoyce 
Check the Action Tool.
Maybe you have Replace the whole path of Excel file including Sheet name.
We should only replace the File name.

[TUSHAR050392]

@michaelcjoyce Are you also trying to update the sheet (12 Month) by some other sheet using action tool?

[michaelcjoyce]

Thank you @Qiu and @TUSHAR050392 

What should I do differently here:

[TUSHAR050392]

@michaelcjoyce If you are trying to update the File with a new one, you should select the File Value and then at the bottom of action tool check the box - Replace a specific string. This way you will be able to update any other file location that you want to enter. Just make sure that the next file location you enter has exact same format and don't use inverted commas in the input - File location|||'Sheet Name$' 

[TUSHAR050392]

@michaelcjoyce Let me know if it worked for you. If it did, mark it solved so that it can help others as well :)

[Qiu]

@michaelcjoyce 
Agree with @TUSHAR050392