Error Handling opening excel workbook from shared network

[Catsonheat]

Hi all,

I have a macro which opens a workbook stored in a shared network drive, so the file path is a hyperlink rather than a C: path. At the moment my macro works fine and opens the link stored in the workbook. However, I want to put in an error handler so that if either the link or filepath/file name has changed when trying to open the workbook, it will provide a notification and then exit the sub as it has been unable to find the file.

Unfortunately when i run the below code, my Excel get's stuck in an infinite loading loop and never gets to the error handler. To trigger the error handler I have to open my task manager and end the new excel instance. I think my code is getting stuck because I have opened a new excel instance which is still open but can't find the file?

Any help would be appreciated.

Please Login or Register  to view this content.

[FDibbins]

THis thread has been marked as SOLVED. If you marked it as such, care to share your answer?
If you did not, do you want it "unmarked"?