Hi.
I'm running macros with Excel 2007 in compatibility mode. One macro uses
the Workbooks.OpenText method to open a text file and import the contents
into a new sheet. It then moves the sheet into another workbook.

I get a runtime error during the "move" operation It has to do with the
fact that OpenText generates a sheet in the new size (1M rows, 16k columns),
while the main document is still in compatibility mode (64k rows, 256
columns). Excel doesn't let you move, because of the size difference.

I can get around this by saving the workbook in the new '07 macro-enabled
format, but I'd like to have a solution that works in compatibility mode
format, for both '03 and '07 users.

Does anyone know of an elegant work-around for this?

Many thanks.