Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default Save As... / Save as Web Page... how to differentiate?

Hi All

I hook myselfe onto the save event (interop) and i would like to
differentiate the event Save As... and the event Save as Web Page...

is there a way to see what button the user clicked out of the Worbook
Object?

thanks for your help

jahrens


  #2   Report Post  
Posted to microsoft.public.excel.programming
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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Save, save as, page setup dimmed out in unprotected excel sheet? ccKeithJ Excel Discussion (Misc queries) 3 December 14th 07 07:07 PM
How do I save one page out of a 80 page report in excel? bellamere New Users to Excel 2 February 15th 06 08:25 PM
Save as Web Page Eva Excel Discussion (Misc queries) 0 February 2nd 06 04:55 AM
Totally Disabling (^ save ) (Save as) and Save Icon – Which code do I use: harpscardiff[_10_] Excel Programming 8 November 10th 05 12:24 PM
Save As Web Page EricP Excel Programming 2 August 11th 04 04:35 AM


All times are GMT +1. The time now is 12:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"