SaveAs another file name, then keep working
 

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


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.591 / Virus Database: 374 - Release Date: 2/17/2004

SaveAs another file name, then keep working
 

Group -- Sorry for the sloppy research.

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

L Mehl


"L Mehl" wrote in message
...
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


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.591 / Virus Database: 374 - Release Date: 2/17/2004




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.591 / Virus Database: 374 - Release Date: 2/17/2004

SaveAs another file name, then keep working
 

Look for .savecopyas in VBA's help.



L Mehl wrote:

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

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.591 / Virus Database: 374 - Release Date: 2/17/2004

--

Dave Peterson