View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PeteMann PeteMann is offline
external usenet poster
 
Posts: 1
Default 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