Need Macro for "MultiTab.xls" --> "SingleTab.xlsx"

[FKoenig]

Hi,

I'm using an application which exports to XLS files. However, many times when I export, the # of rows is over 65,536 and therefore the app exports to multiple sheets. I need a macro which opens this .xls file and combines all of these multiple sheets onto a single sheet, then saves the file as .xlsx.

IE, the Macro would take rows 1 - 65,536 from "Sheet2, Sheet3, ...etc. [# of tabs is variable]", cut them, then paste them at the bottom of Sheet1. So if the original file contained sheets 1 through 3, each with 65,536 rows, then the "finished" file that gets saved would have 1 tab with (65,536*3 = ) 196,608 rows containing all of the data from the original 3 tax in the .xls files.


Any help would be greatly appreciated. I've searched the forums all over and can't seem to find this anywhere.

 

[FKoenig]

Some quick additional data.... Sheet 1 row 1 contains a header row (column/field names) Sheet2 and any other sheets above do not.

Also, the # of columns can change from time to time.

 

[montecarlo2079]

try this page it does exactly what you want

Merge cells from all or some worksheets into one Master sheet

 

[FKoenig]

Not exactly what I'm looking for as it first requires me to open the xls file and save it as xlsx in order to prevent the macro from running out of rows.... but I guess it's a starting place.

Thanks.