GetOpenFile dialog pops up behind Access screen

[Gerry Verschuuren]

My code inside Access creates a reference to Excel (with CreateObject) and
then I call a file-open-dialog box (with GetOpenFileName). All works fine so
far, but then the box pops up behind the Access screen.

First of all, why? Secondly, how can I prevent/change this? Minimizing and
then maximizing the Access screen does not work when other applications are
open.

Does anyone have a solution?

Thanks.

Gerry

 

[Dirk Goldgar]

My code inside Access creates a reference to Excel (with CreateObject) and
then I call a file-open-dialog box (with GetOpenFileName). All works fine
so
far, but then the box pops up behind the Access screen.

First of all, why? Secondly, how can I prevent/change this? Minimizing and
then maximizing the Access screen does not work when other applications
are
open.

Does anyone have a solution?

You're talking about calling Excel's GetOpenFilename method, using your
Excel Application object as a base? I guess the problem is that your Access
application has the focus, so Excel dialog is behind it.

How about using the code here:

http://www.mvps.org/access/api/api0001.htm
API: Call the standard Windows File Open/Save dialog box

.... to call the Windows GetOpenFileName dialog directly from Access? Then
you could pass the file name returned to your Excel object -- assuming you
were using that object for something besides just its GetOpenFilename
method.

 

[Gerry Verschuuren]

Is there perhaps a way I could set the focus from Access to the Dialog Box?

 

[Piet Linden]

Is there perhaps a way I could set the focus from Access to the Dialog Box?

What if you did something like

appExcel.Activate

and then popped the dialog box?