View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
phil-rge-ee phil-rge-ee is offline
external usenet poster
 
Posts: 18
Default 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