FileOpen/FileSave Command doesn't work?

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
 

Forum statistics

Threads
1,082,548
Messages
5,366,227
Members
400,880
Latest member
dwb

Some videos you may like

This Week's Hot Topics

Top