Office Add-in. Trapping/Redirecting CTRL-S

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jason - 22 Oct 2004 23:21 GMT

Built an Office Addin with .net 2003. I have captured the save and save as
menu options so I can run my own code before the regular save function
executes. However, I have not been able to figure out how to do the same with
CTRL-S. Does anyone have any ideas?

Thanks
Jason

Reply to this Message

Gary Chang[MSFT] - 23 Oct 2004 09:48 GMT

Hi Jason.

Currently I am looking for somebody who could help you on it. We will reply
here with more information as soon as possible.
If you have any more concerns on it, please feel free to post here.

Thanks for your understanding!

Best regards,

Gary Chang
Microsoft Online Partner Support

Signature

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

--------------------

Reply to this Message

"Peter Huang" - 25 Oct 2004 06:34 GMT

Hi Jason,

I think you may try to catch the Workbook_BeforeSave event and if you do
not want to do the save, you may just set the cancel to true will prevent
the saving operation.
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
MsgBox "hellO"
Cancel = True
End Sub

Best regards,

Peter Huang
Microsoft Online Partner Support

Signature

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

Reply to this Message

Jason - 25 Oct 2004 08:21 GMT

We're thinking alike..:) I'm having a problem with setting up a reference to
the FrontPage Application object with events..If declared as an object I can
manipulate menu options, toolbars etc...When I Create an appobj with events
and set it during the onConnect event the Toolbar functions fail...

Very weird...Any ideas? Slightly off track but this is stopping me at least
try...

Thanks
Jason

> Hi Jason,
>
[quoted text clipped - 14 lines]
> Get Secure! - www.microsoft.com/security
> This posting is provided "AS IS" with no warranties, and confers no rights.

Reply to this Message

"Peter Huang" - 26 Oct 2004 08:35 GMT

Hi

Are you using VB.NET?
I think you may try to use the Addhandler method.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/
vastmAddHandlerStatement.asp

Also can you post your code and detailed reproduce steps so that we can do
further troubleshooting.

Best regards,

Peter Huang
Microsoft Online Partner Support

Signature

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

Reply to this Message

Jason - 26 Oct 2004 16:49 GMT

Thanks Peter, I have figured it out. The problem was that the PIA for Office
2003 was broken and my install was using the local Interop. Once I reparied
my office install and repointed to the correct objects the Application
declaration with events functions just fine...I then used the beforePageSave
Event to launch my code before the save happens...:) I'm very happy with the
solution, thanks for your help...

Jason

> Hi
>
[quoted text clipped - 13 lines]
> Get Secure! - www.microsoft.com/security
> This posting is provided "AS IS" with no warranties, and confers no rights.

Reply to this Message

"Peter Huang" - 27 Oct 2004 04:32 GMT

Hi

I am glad that the problem has resolved.
Cheers!

Best regards,

Peter Huang
Microsoft Online Partner Support

Signature

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

Reply to this Message

Rate this thread:

Office Add-in. Trapping/Redirecting CTRL-S

Free Magazines