Changing this to provide a bit more information, in a bit better way.
I'm using Microsoft Access to use Excel Automation.
What I'm doing is creating an instance of Excel, then showing the "Open" Dialog with the following code (may not be exact)
This works perfectly using Windows XP, however, when I deploy to Windows Vista the "Open" dialog does not open in front of my Microsoft Access window - the user has to alt-tab to see it.
Both machines use the same version of office - office 2k
is there a way I can get the window pulled to the front?
Thanks for any help
I'm using Microsoft Access to use Excel Automation.
What I'm doing is creating an instance of Excel, then showing the "Open" Dialog with the following code (may not be exact)
Code:
Dim xlApp as Excel.Application
Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = False
XlApp.Dialogs(xlDilogOpen).ShowThis works perfectly using Windows XP, however, when I deploy to Windows Vista the "Open" dialog does not open in front of my Microsoft Access window - the user has to alt-tab to see it.
Both machines use the same version of office - office 2k
is there a way I can get the window pulled to the front?
Thanks for any help
Last edited:
