Prevent "Opening..." alert when opening from VBA

Is there any way to prevent Excel from showing an "Opening..." alert
when accessing a file from the Web via VBA? The dialog pops up in
front of other applications when I want Excel to perform its work in
the background, and takes the focus away from the front window.

Thanks for any clues - I've not been able to figure out a decent query
to archives...

Steven Wallace

try

application.displayalerts=false
'stuff
application.displayalerts=true

tim

"Steven Wallace" <[email protected]> wrote in message
news:[email protected]...
> Is there any way to prevent Excel from showing an "Opening..." alert
> when accessing a file from the Web via VBA? The dialog pops up in
> front of other applications when I want Excel to perform its work in
> the background, and takes the focus away from the front window.
>
> Thanks for any clues - I've not been able to figure out a decent query
> to archives...
>
> Steven Wallace
>