Excel 2000 and SaveAs

  • Thread starter Thread starter Jeanne
  • Start date Start date
J

Jeanne

Running Excel 2000 using VBA. Have 2 workbooks open.
Using VBA can create a 3rd workbook, copy sheets from 1 of
the open workbooks to 3rd, then activate 3rd workbook.
When trying to save book3 using SaveAs however, Excel
closes the 3rd book without saving it and renames 1 of the
original books to new name and saves it.

Any insights would be appreciated.

Thanks,
Jeanne
 
Hi Jeanne,

Maybe there's only one sheet on the first workbook and you're moving it and
not copying.
Verify this and, if you don't have success, post your code here for me or
other people analyzes it.

HTH
 
Back
Top