View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
L Mehl L Mehl is offline
external usenet poster
 
Posts: 73
Default 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