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

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

try

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

tim

"Steven Wallace" wrote in message
oups.com...
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