Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.misc
jaf jaf is offline
external usenet poster
 
Posts: 300
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
fixing links to external files if status shows OK ccac user Excel Discussion (Misc queries) 4 June 13th 08 06:49 PM
External links Snowman Excel Discussion (Misc queries) 0 May 30th 08 06:41 PM
External Links ScottS Links and Linking in Excel 2 May 18th 08 03:06 AM
#Value w external links Tia Excel Discussion (Misc queries) 2 March 2nd 07 09:19 PM
Excel 2003: Temporarily "turning off" links to external files... Birmangirl Excel Discussion (Misc queries) 1 August 19th 05 02:51 PM


All times are GMT +1. The time now is 05:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"