View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter Huang [MSFT] Peter Huang [MSFT] is offline
external usenet poster
 
Posts: 225
Default Save As... / Save as Web Page... how to differentiate?

Hi

Based on my research, it is hard to do that.
The Excel Object Modal did not expose such interface for us to detect that.
Although Save As... and Save as Web Pag are two different menu button, but
they are buildinly firing the same event.
WorkBook_BeforeSave event

But the event parameter did not expose any information about the save type.
Because as the event named, it is before save.

If you still have any concern, please feel free to post here.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.