WorkbookBeforeSave does not fire on save

Add-in Express™ Support Service
That's what is more important than anything else

WorkbookBeforeSave does not fire on save
 
Fred Kestler




Posts: 2
Joined: 2011-01-05
I have the following code snippet in the AddinModule.vb file:

Private Sub adxExcelEvents_WorkbookBeforeSave(ByVal sender As System.Object, ByVal e As AddinExpress.MSO.ADXHostBeforeSaveEventArgs) Handles adxExcelEvents.WorkbookBeforeSave
e.Cancel = True
MsgBox("test 2")
End Sub

For some reason, when I hit the save button in Excel this code does not get initiated. Does anyone have any ideas?

Thanks.
Posted 05 Jan, 2011 13:01:39 Top
Eugene Astafiev


Guest


Hi Fred,

I have just tried to reproduce the issue on my PC. It works as expected on my PC with Excel 2007 SP2. Please make sure that your add-in is loaded by the host application.

I have a bunch of questions:
1. What version and build number of Add-in Express do you use?
2. Excel version and SP number?
3. Did you installed the latest service packs for Office and .net?
4. Could you please show me the adxloader.log file (typically it is located in the <My Documents>\Add-in Express folder)?

And the last question: Did you register the add-in before?
Posted 06 Jan, 2011 07:25:28 Top
Fred Kestler




Posts: 2
Joined: 2011-01-05
Eugene,

Thanks for your reply. I decided to take a different approach and added a Ribbon bar instead. It works perfectly. Great tool.

Regards,

Fred
Posted 06 Jan, 2011 10:20:23 Top
Eugene Astafiev


Guest


You are welcome, Fred!
Posted 06 Jan, 2011 10:26:51 Top