I have several sheets set up and have macros to open other sheets.
My issue is the network I am on uses different drive letters for different people, (e.g. I am on T:\, but my colleague is on S:\)
I seem to need to put in the full file path in the macro to open the sheet I need.
Is there a way to not have to include the whole file path in the macro?
Also, I have links to the other sheets within the original file that contains the macro.
thanks
Last edited by BillDoor; 01-04-2013 at 05:03 AM.
I did try using the UNC file path, but for some reason, when the file is opened from the non-UNC file path (just opened though explorer so has T:\ as the start) it messes up the file path, it seems to add extra parts in, so the links do not work. This is all in 2007 btw
Is it ok if the macro prompts you to open the file ?Is there a way to not have to include the whole file path in the macro?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
I'd prefer it if it didn't, as some of them are in the auto_open macro
Hi, Is there a way to do this?
Bill,
Perhaps a silly question, but is the workbook from where the code is run, perhaps on the network drive itself? In other words for you the master workbook would be stored be on T:\..\ while for another user the master workbook would be stored on S:\..\ purely because his/her home drive is mapped to another drive letter?
If you like my contribution click the star icon!
Hi
yes, I suppose, I can either access the files through the T: drive, or I can go to the UNC map to get to it. My colleagues would be able to access through the two same routes, but different drive letter
Bill,
You can use the following code to find existing mapped network drives for a user. Assuming the objects are on a specific server, you would be able to find the correct map drive dynamically.
Please Login or Register to view this content.
Ollie
thanks for the reply, but I can't see how this will help my problem, I don't really need to know what drive letter it is mapped to (I already kow that) what I need is a way for the macro to try and open the file on T: or S:
thanks
Bill the drive letter mapping is different for each workstation, I get that. However in the end drives will always map to a network drive which starts with the server name. Assuming the workbook objects will always be on the same physical server you can use the code provided to determine which path is the desired one.
A bit of example code:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks