chadjones123
New Member
- Joined
- Aug 27, 2009
- Messages
- 1
Hey!
So I am having an issue that I can not seem to figure out here... I want to be able to use my own custom dialog box when a user requests and Open or a Save (in Office 2007). I can do this via VBA and macros, but I have a shared add-in that I have created in VS2008 that does this for me. All seems to work well in Word, but not in Excel? It appears that the FileOpen/FileSave command does not get executed when the user uses the Ctrl+O/Ctrl+S hotkeys. Thus, displaying Excels open dialog instead of my own.
I even tried creating a macro to call the command as follows, but to no avail as the Excel open dialog is still displayed:
Sub FileOpen()
CommandBars.FindControl(ID:=23).Execute
End Sub
Does anyone know how I can successfully execute the FileOpen command when the user presses Ctrl+O or Ctrl+S from within the Add-in? Or perhaps a macro to call this?
Thanks,
Chad
So I am having an issue that I can not seem to figure out here... I want to be able to use my own custom dialog box when a user requests and Open or a Save (in Office 2007). I can do this via VBA and macros, but I have a shared add-in that I have created in VS2008 that does this for me. All seems to work well in Word, but not in Excel? It appears that the FileOpen/FileSave command does not get executed when the user uses the Ctrl+O/Ctrl+S hotkeys. Thus, displaying Excels open dialog instead of my own.
I even tried creating a macro to call the command as follows, but to no avail as the Excel open dialog is still displayed:
Sub FileOpen()
CommandBars.FindControl(ID:=23).Execute
End Sub
Does anyone know how I can successfully execute the FileOpen command when the user presses Ctrl+O or Ctrl+S from within the Add-in? Or perhaps a macro to call this?
Thanks,
Chad