VBA - Opening a workbook on a network

Hi All,

As above i have a macro which opens a workbook which is on a network drive. This works fine for my multiple users...however i have discovered that if they do not have the drived mapped with the same drive letter at the start...it will throw up an error advsing that the file does not exist.

Is there any way to by pass this.

Ex - "TestFile.xls"

File is stored in "E:\Network\Team1\Testfile.xls"

However, some users have access to this file and it is mapped as E:, but some users have been mapped as F: The advisors who have been mapped as F: cannot access the file.

Is the VBA/Macro smart enough to bypass the drive letter and just search the rest of the past...Network\Team1\Testfile.xls".

Many Thanks

If you only have two mappings why not just check for the existing of the file before openning it.

Please Login or Register  to view this content.

Or if you know the server name, obviously replace <servername> with actual name.

Please Login or Register  to view this content.