SaveAs another file name, then keep working

  • Thread starter Thread starter L Mehl
  • Start date Start date
L

L Mehl

Hello --

I want the user of a workbook to be able to SaveAs (enter another filename)
and then be able to continue working in the original workbook.

I can get my code to perform the save, but then the saved-as workbook is
open, and I can't figure out the code to re-open/show the original workbook.

I saw a "...SaveAs ... Backup..." method somewhere, but can not find it now.

Thanks for any help.

Larry Mehl
 
Group -- Sorry for the sloppy research.

I just found SaveCopyAs in this group, and will dig into it.

L Mehl
 
Look for .savecopyas in VBA's help.



L said:
Hello --

I want the user of a workbook to be able to SaveAs (enter another filename)
and then be able to continue working in the original workbook.

I can get my code to perform the save, but then the saved-as workbook is
open, and I can't figure out the code to re-open/show the original workbook.

I saw a "...SaveAs ... Backup..." method somewhere, but can not find it now.

Thanks for any help.

Larry Mehl
Click to expand...
 
Back
Top