L
LarryP
I have an Access 2003 database where a particular button click on a form is
supposed to open an Excel file with macros. The first thing the Excel macro
does is open a form where the user makes various selections.
I'm opening the Excel file now with a Shell() command, but would prefer to
use a hyperlink. Problem is, when I do so the Excel form pops up on top of
my Access screen, and the Excel worksheet is hidden somewhere behind all
that. It doesn't become visible until the user completes his selections on
the Excel form and closes it, at which time Excel comes to the front. This
does NOT happen with the Shell() command.
I presume this is something to do with the Excel form being perceived as
modal by Access, but I don't understand why the only the hyperlink approach
has this problem, and I don't know the fix. What can I do in VBA so when
that button is clicked, the screen order front to back is Excel form - Excel
Worksheet - Access form?
supposed to open an Excel file with macros. The first thing the Excel macro
does is open a form where the user makes various selections.
I'm opening the Excel file now with a Shell() command, but would prefer to
use a hyperlink. Problem is, when I do so the Excel form pops up on top of
my Access screen, and the Excel worksheet is hidden somewhere behind all
that. It doesn't become visible until the user completes his selections on
the Excel form and closes it, at which time Excel comes to the front. This
does NOT happen with the Shell() command.
I presume this is something to do with the Excel form being perceived as
modal by Access, but I don't understand why the only the hyperlink approach
has this problem, and I don't know the fix. What can I do in VBA so when
that button is clicked, the screen order front to back is Excel form - Excel
Worksheet - Access form?