| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Too Many Cell Formats" Error when opening a 2007 XLS file in 2003 | Excel Discussion (Misc queries) | |||
| How do I prevent "Help" from opening when I open Excel? | Excel Discussion (Misc queries) | |||
| programmaticaly test more then 1000 excel files for "opening Errors" | Excel Programming | |||
| METHOD "SELECT" OF OBJECT '_WORKSHEET' FAILED when opening a file | Excel Programming | |||
Linear Mode
