| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Intercepting Save and Exit menu command in Excel
Hi,
I have a programming need to be able to intercept the menus "File/Open", "File/Exit", "File/Save" and "File/SaveAs" within Excel. I've managed to do this in Word by overwriting the "FileOpen" "FileExit" "FileSave" and "FileSaveAs" macros, which then drive a c# com object to stream the data to (or from) a seperate server. Is this possible within Excel, and if so, what are the Macro names to overwrite? Thanks for any help or pointers, Pete |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Intercepting Save and Exit menu command in Excel
Pete,
In the ThisWorkBook module you can create event macros Workbook_Activate Workbook_BeforeClose Workbook_BeforeSave Workbook_Deactivate Workbook_Open Play with these and put in your conditions and what you want... -- steveB Remove "AYN" from email to respond "PeteMann" wrote in message ... Hi, I have a programming need to be able to intercept the menus "File/Open", "File/Exit", "File/Save" and "File/SaveAs" within Excel. I've managed to do this in Word by overwriting the "FileOpen" "FileExit" "FileSave" and "FileSaveAs" macros, which then drive a c# com object to stream the data to (or from) a seperate server. Is this possible within Excel, and if so, what are the Macro names to overwrite? Thanks for any help or pointers, Pete |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does Excel ask to Save on Exit? | Excel Discussion (Misc queries) | |||
| excel save file upon exit | Excel Discussion (Misc queries) | |||
| Excel - Prompt to save on exit. | Excel Discussion (Misc queries) | |||
| Excel 2003 Will Not Save On Exit | Excel Discussion (Misc queries) | |||
| How do i create a command button or macro to exit Microsoft Excel | Excel Worksheet Functions | |||
Linear Mode
