Macro Goes to Error Handler even after form opens

[ut1anderson]

After Front Lines Summary opens, macro still goes to errorhandler1 insteading of going to "else".
Workbook is on a Shared Drive

[tehneXus]

what do you expect as a result here:

Please Login or Register  to view this content.

number? boolean?

Works fine for me btw

[ut1anderson]

The goal is:
1) Check if Front Lines Summary work book is already open,
2) If not open, open it or
3) in case Front Lines Workbook was deleted provide an error message warning operator that work book has been moved or deleted.

I manipulated that from a code I found but might have screwed it up in the process. The issue I am having right now is that the Front Lines Summary will open using the macro but it still goes to the error handler and provides a message box saying "The Front Lines Summary Sheet has been moved or deleted from the MFG SHOP USER SUMMARY FOLDER."

[tehneXus]

like this?:

Please Login or Register  to view this content.

[a8015945]

Im not sure if tehneXus has got the coding spot on but has the right idea

I had a very similar problem when do a macro recently.
The label ErrHandler1 is just a reference point in the code, a go-to point. When the macro reaches this point it carries on, it doesnt just skip over it.

Please Login or Register  to view this content.

This edited code will open the file and Goto Label1, therefore bypassing ErrHandler1

[tehneXus]

Hi,

I got the problem and suggested a slightly different approach as I wouldn't use more than one (error handler) goto-mark in the code, at some point when your code might grow bigger you'll know what i mean