| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Do you want to save the changes you made to 'ABC.xls'?
That did it.
THANK you - Bob "Gary''s Student" wrote: When Excel has focus, touch ALT-F11 to bring up VBA. Go to the left-hand pane and right-click the ThisWorkbook icon in the small object tree. Select View Code. Paste the stuff in and close the VBA window. MANUALLY SAVE THE WORKBOOK. You may not get a change again, cause you won't be prompted. -- Gary''s Student gsnu200709 "Bob Barnes" wrote: Gary - thank you. I'm almost completely an Access Programmer. Where do I find the module to enter this code? TIA - Bob "Gary''s Student" wrote: 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 |
| Reply |
| 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) | |||
Hybrid Mode
