I have created a batch macro for a consolidation automation workflow for my company. It is very straightforward - Control Parameter (FullPath) -> Action Tool (Update Value file, replace specific string) -> Input tool (aimed at first file in folder, tab name, cells A9:K37) -> macro output.
The files in the folder are .xlsm files that get sent to me by divisions for monthly reclass, and all of the required data to get is on a tab with the same name in each file from cells A9:K37 with row 9 being the headers.
From the Directory tool to the macro on the main canvas, it runs, and attempts to get the other file data, but I get the error "Error: Home Batch (13): Record #2: Tool #5: The field schema for the output "Output5" changed between iterations."
I have gone into the files to ensure that the formatting is the same in these cells, ,all columns are General in excel except 1, which is Accounting. I've even used format painter from one file to the same cells in the other files to try to get it to work.
I have also tried a Select and Union tool in the macro before the macro output to try an lock the types of each field before it goes to the main workflow, but that didn't work.
Any help would be appreciated, will be happy to share any non-confidential info that could assist on this issue.
