| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
prompt to save when already saved
I have a macro in a blank workbook that opens, updates and closes other
workbooks. The below 3 lines are what I repeat for the files to update. Why do I still get the "Do you want to save your changes..." prompt when it closes a file? Workbooks.Open Filename:="aaa.xls", UpdateLinks:=True Workbooks("aaa.xls").Save Workbooks("aaa.xls").Close |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
prompt to save when already saved
works for me, you can try the save and false for saving changes since you
already did Workbooks("aaa.xls").Close (False) -- -John Please rate when your question is answered to help us and others know what is helpful. "Scooter" wrote: I have a macro in a blank workbook that opens, updates and closes other workbooks. The below 3 lines are what I repeat for the files to update. Why do I still get the "Do you want to save your changes..." prompt when it closes a file? Workbooks.Open Filename:="aaa.xls", UpdateLinks:=True Workbooks("aaa.xls").Save Workbooks("aaa.xls").Close |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prompt for saving a saved workbook | Excel Programming | |||
| prompt user to save file as {desired_name} and save it to a variab | Excel Programming | |||
| save prompt for user exit, but no save prompt for batch import? | Excel Discussion (Misc queries) | |||
| 'document not saved' for 'save' or 'save as' an EXCEL file | Excel Discussion (Misc queries) | |||
| internet explorer (ie) issue with activeworkbook.saved (save prompt) AAARGH. | Excel Programming | |||
Linear Mode
