| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Confused here Prevent Saving File - but allow ONLY File SAVEAS Met | Excel Discussion (Misc queries) | |||
| saveas CSV file | Excel Discussion (Misc queries) | |||
| File saves ok, SaveAs VERY slow | Excel Discussion (Misc queries) | |||
| SaveAs command when a file already exists? | Excel Programming | |||
| VBA capture File SaveAs Event | Excel Programming | |||
Hybrid Mode
