Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling the "could not open" notification
Sorry, I have looked extensively but could not find this on my own.
In VBA code: 1) Is there a way of disabling the notification that Excel was not able to open a file? And to try to kill two birds with one stone: 2) Is there similary a way of also disabling the window that tells you it is (trying to / in the process of) opening a file Thanks Alfredo |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling the "could not open" notification
1) Use On Error
on error resume next set myWS = Workbooks.Open("MyFile.xls") on error goto 0 if myWS is nothing then msgbox "File not found" exit sub end if 2) Didn't understand the question HTH -- AP |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling the "could not open" notification
Thanks.
I will use that, and/or a combination with: Application.DisplayAlerts = False Application.DisplayAlerts = True ... which I only just discovered. "Ardus Petus" wrote: 1) Use On Error on error resume next set myWS = Workbooks.Open("MyFile.xls") on error goto 0 if myWS is nothing then msgbox "File not found" exit sub end if 2) Didn't understand the question HTH -- AP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disabling the "&[Time]" or "&[T]" in Excel headers and footers | Excel Discussion (Misc queries) | |||
"File in Use" notification works on some machines, not on others | Setting up and Configuration of Excel | |||
Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Excel Discussion (Misc queries) | |||
Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Setting up and Configuration of Excel | |||
Disabling "SAVE AS" option under "File" | Excel Discussion (Misc queries) |