Excel from VBA/Popup Form/Modal Issue

L

LarryP

I have an Excel workbook with a macro that starts by opening a form. In
Excel that's fine, the workbook opens and the form opens on top of the
workbook. But I need to open that workbook from Access VBA, and when I use
Application.FollowHyperlink, the form pops up on top of the Access window,
with the Excel workbook nowhere to be seen until the user closes the popup
form. I haven't been able to figure out what if anything I need to change to
get the result I want: Excel workbook on top of Access, popup form on top of
Excel workbook. Suggestions?
 
L

LarryP

I fixed this by abandoning FollowHyperlink in favor of a Shell call, but I'd
still like to know why the result with Hyperlink is the way it is -- the
Shell call works fine.
 
Top