On Sat, 21 Nov 2009 15:51:01 -0800, Joel
wrote:

I tested the code with 2003 and had to remove some of the rows to fully test
the code. I guess you just need to do a workboook saveas on the as a xlsx
file after opening the xls workbook.


That never worked for me either as it saves as a compatibility file
mode.

I have to explicitly add a new workbook, and save that as an xlsx file,
and then mark and paste the other sheets in. I have to mark and paste
only the data as well, because marking the entire sheet causes the paste
to fail.

One problem will be that that block size will vary from day to day.
I manually move to the end of the sheet data in the macro, but that would
nee to be dynamic.

currently I start at A1 and do a Ctrl-Shift-End to mark only the data
(plus one row oddly enough).

That allows pasting. Making the entire sheet does not.

I could copy all three sheets over, and then do the stack up there. That
might work.

Thanks for all your help. I wrote another post showing what I came up
with.

Meow