| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save as
Hi, I am attempting to save a work book as another file name using the
Application.Dialogs(5).Show I am then doing setting the active page Worksheets("LS_ORDER_FORM_1").Activate The problem I am having is it seems that the original is still open because the data then cannot be saved properly on the new file. Could it be that both are open for a period? Can a person ensure that the original workbook is closed before doing any processing on the new? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save as
When you do a saveas, the old workbook name becomes the new workbook name.
There is no period of time when two workbooks exist. -- Regards, Tom Ogilvy "John" wrote in message ... Hi, I am attempting to save a work book as another file name using the Application.Dialogs(5).Show I am then doing setting the active page Worksheets("LS_ORDER_FORM_1").Activate The problem I am having is it seems that the original is still open because the data then cannot be saved properly on the new file. Could it be that both are open for a period? Can a person ensure that the original workbook is closed before doing any processing on the new? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save as
Then I don't get the problem. Do you have to set the ActiveWorkbook somehow
after the save as? If so how would a person do that? "Tom Ogilvy" wrote: When you do a saveas, the old workbook name becomes the new workbook name. There is no period of time when two workbooks exist. -- Regards, Tom Ogilvy "John" wrote in message ... Hi, I am attempting to save a work book as another file name using the Application.Dialogs(5).Show I am then doing setting the active page Worksheets("LS_ORDER_FORM_1").Activate The problem I am having is it seems that the original is still open because the data then cannot be saved properly on the new file. Could it be that both are open for a period? Can a person ensure that the original workbook is closed before doing any processing on the new? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save, save as, page setup dimmed out in unprotected excel sheet? | Excel Discussion (Misc queries) | |||
| how to get disk icon on save button of save as dialog like 2000 | Excel Discussion (Misc queries) | |||
| when i save xls file, debug script is running and canno't save fil | Excel Discussion (Misc queries) | |||
| Save Excel file - prompts to save - no Volitile functions used | Excel Worksheet Functions | |||
| Why system asks me to save change even after I call save method(VB.NET) | Excel Programming | |||
Linear Mode
