| Home |
| Search |
| Today's Posts |
|
|
|
#1
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) | |||
Hybrid Mode
