Integrating a VB App with Excel 1

[VBRookie]

Hi,

I have successfully integrated Excel with my VB app by displaying the automation server inside of a frame as opposed to using an OLE control.

I've disabled all of the menu items in Excel and placed a save button on the form so the user can only manipulate it through the VB app.

I'm using the following code to bring up the 'Save As' dialog box when they click save:

With mxlApp.CommandBars("Worksheet Menu Bar")
     .Controls("File").Controls("Save As...").Execute
End With

The problem is that when I click save the application disappears although it's still running. I have to click on it from the menu bar to make it the active window again. When it comes back into view the Save As dialog is there but how do I stop the app from going into the background or hiding itself when I click on save?

Any help would be greatly appreciated. Thanks.
- VBRookie

 

[ratman]

Consider this:

activewindow.visible=true

If this doesn't work email me we can try something else.....possibly using the prevent save as routine I have or taking control of the Application.Dialogs command options.
email me at drat@mediaone.net if you want to talk.

Ratman