Open workbook from network location - error handling

**supern0va** · 07-10-2012, 07:05 AM

One of the steps in a marco I'm working on is opening a workbook from another drive.
I've specified the location of the workbook with a private function:

Please Login or Register  to view this content.

It is on a network drive.
This means of course that depending on the user's physical location, the macro may or may not be able to find the network path.
How do I handle the possible error for this? My first idea was something like

Please Login or Register  to view this content.

This should also give you some idea of the VBA skill level I'm at

Any pointers in the right direction are welcome!

**Steffen Thomsen** · 07-10-2012, 07:12 AM

Hi,

I suggest you have a look at this page

http://www.vbaexpress.com/kb/getarticle.php?kb_id=559

Here you get a code sample and how to use it, to check if a directory exists.