Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stopping error messages from popping up - part 2
Ok, I got another one. I click on a button and it runs this code:
Private Sub cmdEnterScores_Click() ChDir "C:\WINDOWS" Workbooks.Open FileName:="C:\WINDOWS\datasheet2006.xls" (more non-important code here) If the datasheet2006.xls does not exist I get a VB error telling me so and the script halts. How do I code it so that if the datasheet.xls does not exist I can pop up my own msgbox instead of the vb script error box? Thanks, Phil |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stopping Auto calculation in Part of a Worksheet | Excel Worksheet Functions | |||
Stopping "Query Refresh" messages | Excel Discussion (Misc queries) | |||
Stopping "Query Refresh" messages | Excel Discussion (Misc queries) | |||
Stopping windows installer from popping up all the time | Excel Discussion (Misc queries) | |||
All macros failing part way through with different error messages | Excel Discussion (Misc queries) |