Read multiple files with mismatched columns number , names

Question

I have 20.  Excel files containing mismatched number of columns and names .

I need a specific set of columns ,some files might have different names to those columns

I need to process each file , get specific columns and generate output file for each input with datetime added to the output filename

i tried setting up the following

dir —-> macro [ macroinput(fullpath) —-> dynamicInput—-> formula —- select —> macro output]   —-> outputtool

but dynamic tool still complains that second file has mismatched columns , i thought putting in macro would do it

please help

binu_acs · Answer

@nitin_ks try the below batch macro, the first macro reads the input file and the sheet name, inside the second macro you need to make your changes

Multiple_Excel_Output_17032025.yxzp

nitin_ks · Answer

Only 1, but could have different name

binu_acs · Answer

@nitin_ks how many sheets are present in each of the Excel input files?