Changing a link from excel file to word file

[Marckas]

I am trying to change the link of an excel file to a word file. I know you do it through VBA but my problem is that both these files are on a network drive in the same folder. When I try to access it from home by VPN or remote access the link does not work. I think the link is hard coded like : "L:\\P.doc". Is there any way I could not hard code it to the L: and just leave both files in the same folder. What code do I use. How do I do this, because when I am in my office it works and when I access in from home, it doesnt even though I have permission and rights to access the network drive. Please Help!!

 

[sxschech]

Have you tried UNC? Find out what "L:" is, something like \\sfos009\users and then replace L: with the \\sfos009\users, then you don't need to worry about the drive letters. Of course, if there are security issues, this probably won't help.

 

[macropod]

Hi Munaf,

To see how to implement relative paths in Word, check out the solution I've posted at:

http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=670027

For the Excel files, which use LINK fields, you'll need the macro solution.

Cheers

[MS MVP - Word]