Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keep original wkbk open after SaveAs?
I open a "template" workbook, throw in some information and then do SaveAs
to create a new workbook. After I finish with the new workbook, though, I'd like to go back and add some more stuff to the original "template". SaveAs, though, closes the original and leaves me with just the new workbook. Is there any way to leave the "template" workbook open to write to? Ed |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keep original wkbk open after SaveAs?
Hi Ed,
Ed wrote: I open a "template" workbook, throw in some information and then do SaveAs to create a new workbook. After I finish with the new workbook, though, I'd like to go back and add some more stuff to the original "template". SaveAs, though, closes the original and leaves me with just the new workbook. Is there any way to leave the "template" workbook open to write to? Look at the SaveCopyAs method - it does exactly what you're looking for. -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keep original wkbk open after SaveAs?
Many thanks, Jake!
Ed "Jake Marx" wrote in message ... Look at the SaveCopyAs method - it does exactly what you're looking for. -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif Error when Referenced Wkbk not open | Excel Discussion (Misc queries) | |||
Excel won't open the original document!!! | Excel Discussion (Misc queries) | |||
Open Object as Wkbk opens | Excel Programming | |||
Macro to open SaveAs... and change filename to cell value | Excel Programming | |||
Error Message Wkbk Open | Excel Programming |