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
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?