Hello,
My Batch Macro that was working fine suddenly stopped working and I cannot seem to determine the problem.
This set of files are working fine. The filenames go into the macro and it spits out the data from the sheet.
Using the exact same Macro, the below set simply returns nothing.
Macro details for reference. What am I missing?! Is there a way to see the details of the macro run? Sidenote, the two examples above are a part of the same workflow. I have some xlsm files and created a separate macro for those that is also returning nothing. I also thought it was because of the files mapped through SharePoint through my C drive, but I have another workflow also using this macro through sharepoint files working just fine.
Hi @aimeegoins
There is go to RunTime tab in the configuration window and check the option show macro messages. Refer below.
Hope this helps : )
Thanks! So I did that and it looks like it's grabbing the files.. but there is data on them and it's giving me nothing.
When I select the file from here to try to open it I get this error:
Only 2 warnings and don't seem relevant, they're at the end of the Workflow and the macros are early.
@aimeegoins , the most common mistake I commit on batch macros is when I replace a file inside the macro for some test and I forget to update the Action tool that changes the input data. See if it's not your case.
I've checked that as well and it is not the case.
I ran an interesting test this morning using one file that worked perfectly at first with no filter, then with a filter. However, when I switched the filter to a Text Input and Join it stopped working. It also caused the Filter portion to stop working. The filenames enter the macro and nothing comes out even though the messages say it is gathering the information.
When I try to open one of the links from the Batch notes I am getting the Unhandled Exception occurred error.