Batch Macro Working with Some Files but not all
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Batch Macro
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @aimeegoins
There is go to RunTime tab in the configuration window and check the option show macro messages. Refer below.
Hope this helps : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Only 2 warnings and don't seem relevant, they're at the end of the Workflow and the macros are early.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
Sales Engineer - LATAM -
Alteryx, Inc.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
