Prior to Excel 2007, we used to catch the open file event in Excel using vba so that we could show our own open dialog that knew how to find client folders. In Excel 2007 this no longer works, does anyone have any ideas on how it works now>
The basic premise before was create a class with a commandbar button and a related event and then set that commandBarButton when the app opened and it would catch it, but now it does not. Is there another way now?
Public WithEvents cmdBold As Office.CommandBarButton
Private Sub cmdBold_Click (ByVal Ctrl As Office.CommandBarButton, _
CancelDefault As Boolean)
' Insert code you want to run in response to this event.
End Sub
http://msdn.microsoft.com/en-us/library/aa189726(office.10).aspx
Best Answer
Not really up to speed with 2007 yet but I think that the change to the Ribbon UI has changed the way your application works.
From the "Developer Considerations" section of this lengthy MSDN article:
So, you may well find that you have an additional "Open" control in the Add-Ins tab.
It seems that re-purposing the built-in control is only possible using XML. From earlier in the same document:
Finally, this even longer MSDN article explains how XML customization works