Intercepting Save and Exit menu command in Excel

P

PeteMann

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
 
S

STEVE BELL

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Intercepting Save / Exit Menu Commands in Powerpoint 0
save and exit macro 8
Excel template and default save name 1
excel 2003 vs 2007 menu and sheet issues 3
Save Dialog pops up now - Excel 2007 1
Private Sub Workbook_BeforeSave 2
Catch File>Save/Save As/etc... 4
Looping Open and Save as CSV 9

Top