View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Kevin Stecyk Kevin Stecyk is offline
external usenet poster
 
Posts: 74
Default Disable "File Not Found" dialog box

Sandy,

Before the offending line of code....

On Error Resume Next

After the offending line of code...
On Error GoTo 0

This turns off error and turn on error handling.

Best regards,
Kevin H. Stecyk

"Sandy" wrote in message
...
Hello!

I am working on code that opens a workbook, does stuff
with it, and then closes it. It is linked to two other
workbooks that cannot be in the same folder, therefore, I
keep getting the "File Not Found" dialog box which I have
to click close on each time I run the code. How can I get
rid of this annoying thing? I looked through Help and
couldn't find the designation fot this particular dialog
box (even more annoying!).

Any help will be greatly appreciated!

Sandy