| 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? |
| 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 | |||
Threaded Mode
