| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Do you want to save the changes you made to 'ABC.xls'?
Put the following macro in the workbook in ThisWorkbook code:
Private Sub Workbook_BeforeClose(Cancel As Boolean) ThisWorkbook.Saved = True End Sub -- Gary''s Student gsnu200709 "Bob Barnes" wrote: I'm running Automation from Access-to-Excel. As the Procedure ends, within Access, I'm getting the "Subject" Message above. I've run Automation from Access-to-Excel many times...but now this message on this one File. Any way to turn that off? TIA - Bob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why does excel ask to save changes when none have been made? | Excel Discussion (Misc queries) | |||
| save changes when no changes made | Excel Discussion (Misc queries) | |||
| File Save although no changes were made | Excel Discussion (Misc queries) | |||
| Excel2000 keeps asking me to save when no changes were made | Excel Discussion (Misc queries) | |||
| Save prompt when no changes made | Excel Discussion (Misc queries) | |||
Threaded Mode
