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