Batch Macro Multiple File Input Missing Header

[harithahamad]

Hi all,

Would like to get some inputs from the experts. I'm using a batch macro to consolidate multiple files into 1 file. However, my result is always missing 1 or 2 headers/column, and when I checked against the source file, it's always the last or last two columns which are missing.

Say:

Input File 1 (12 column headers)  -> Batch Macro Input -> Output File 1 (10 column headers)

Does anyone has an idea how to overcome this? The source file that I'm using is a .xls file which I wonder, would that be the reason/issue for this? Appreciate any inputs.

Thanks!

Harith

[harithahamad]

Actually, I did a further check on this. I tried an input one of the source file (which is an .xls), and the ouput is also missing the last 1 or 2 column headers. Hence, I'm guessing it's the file type .xls is the issue.

I'm wondering is there any workaround for this issue?