Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links to external files
I am creating an excel 2007 file that contains links to different document
files. Basically the client wants a system that contains brief information from a document, and i want to include a link the the file within the directory structure. My problem is that the "hard coded" file link will not remain the same when the client is given the directory. currently the structure is like :companyserver\office location\project\sub folder\THIS DIRECTORY\Sub folder1\Subfolder 2\File.doc the .xls file will reside in the THIS DIRECTORY and the documents will be in the sub folder2 folder. I want to be able to copy the "THIS DIRECTORY" folder and have the links still work Is this doable? is it clear what i want to accomplish? Thanks for your help guys. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links to external files
What you want to do will not work. Linked files can not be moved. The path is
hard coded and the file does not know that it has been moved as moving files is handled by the operating system. -- HTH... Jim Thomlinson "Shades" wrote: I am creating an excel 2007 file that contains links to different document files. Basically the client wants a system that contains brief information from a document, and i want to include a link the the file within the directory structure. My problem is that the "hard coded" file link will not remain the same when the client is given the directory. currently the structure is like :companyserver\office location\project\sub folder\THIS DIRECTORY\Sub folder1\Subfolder 2\File.doc the .xls file will reside in the THIS DIRECTORY and the documents will be in the sub folder2 folder. I want to be able to copy the "THIS DIRECTORY" folder and have the links still work Is this doable? is it clear what i want to accomplish? Thanks for your help guys. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links to external files
Is there a way to accomplish this or is it just not possible?
"Jim Thomlinson" wrote: What you want to do will not work. Linked files can not be moved. The path is hard coded and the file does not know that it has been moved as moving files is handled by the operating system. -- HTH... Jim Thomlinson "Shades" wrote: I am creating an excel 2007 file that contains links to different document files. Basically the client wants a system that contains brief information from a document, and i want to include a link the the file within the directory structure. My problem is that the "hard coded" file link will not remain the same when the client is given the directory. currently the structure is like :companyserver\office location\project\sub folder\THIS DIRECTORY\Sub folder1\Subfolder 2\File.doc the .xls file will reside in the THIS DIRECTORY and the documents will be in the sub folder2 folder. I want to be able to copy the "THIS DIRECTORY" folder and have the links still work Is this doable? is it clear what i want to accomplish? Thanks for your help guys. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links to external files
Hi,
The easy answer is no. It won't work. There is a work around. You need to create a path and turn it into an environment variable like... Temp="%USERPROFILE%\AppData\Local\Temp" So your path needs to be Shades_widgit=%servername%office location\project\sub folder\THIS DIRECTORY Or maybe Shades_widgit=%servername%\%office location%\project\sub folder\THIS DIRECTORY (not sure if you mean company branch office or MS Office.) I've never tried to create one so I can't help more. Obviously you will need to create the environment variable in a setup progie and possibly get the servername as input. Check this out. http://www.microsoft.com/resources/d....mspx?mfr=true John "Shades" wrote in message ... Is there a way to accomplish this or is it just not possible? "Jim Thomlinson" wrote: What you want to do will not work. Linked files can not be moved. The path is hard coded and the file does not know that it has been moved as moving files is handled by the operating system. -- HTH... Jim Thomlinson "Shades" wrote: I am creating an excel 2007 file that contains links to different document files. Basically the client wants a system that contains brief information from a document, and i want to include a link the the file within the directory structure. My problem is that the "hard coded" file link will not remain the same when the client is given the directory. currently the structure is like :companyserver\office location\project\sub folder\THIS DIRECTORY\Sub folder1\Subfolder 2\File.doc the .xls file will reside in the THIS DIRECTORY and the documents will be in the sub folder2 folder. I want to be able to copy the "THIS DIRECTORY" folder and have the links still work Is this doable? is it clear what i want to accomplish? Thanks for your help guys. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fixing links to external files if status shows OK | Excel Discussion (Misc queries) | |||
External links | Excel Discussion (Misc queries) | |||
External Links | Links and Linking in Excel | |||
#Value w external links | Excel Discussion (Misc queries) | |||
Excel 2003: Temporarily "turning off" links to external files... | Excel Discussion (Misc queries) |