Absolute/Relative paths?

  • Thread starter Thread starter denisecook
  • Start date Start date
D

denisecook

Hello again,

I need some assistance with making a project use relative paths instea
of absolutes? It's not a web project though so I didn't even know thi
was necessary. What happened is that I created this project consistin
of several worksheets using external data ranges to get data from eac
other. I created it on our server at work, burned it to a cd and too
it home to work on. At home the files won't refresh data becaus
they're looking for data that can't be found - even though its all o
the cd. The filename it looks for however has the entire path to m
server. I need this to be portable so I can just zip it all up an
hand it over to the group that will use it and the folders should b
able to refresh data and work independently. Is there something I nee
to do? I didn't hard code the path in there, just set my links a
normally...

Thanks
 
Denise...

I may be misinterpreting your message, but it sounds like you hav
linked to cells in a workbook that resides on your server, then save
all of the workbooks to a CD to work on them at home. If that is th
case, I believe that you would have to have all of the workbooks in th
same relative location (such as a created folder in the same location
for the links to hold after you have saved them to a CD. If all of th
workbooks originally reside in a folder on your server when you creat
the links, then the links should still work...provided that you cop
the entire folder to a CD
 
I need some assistance with making a project use relative paths instead
of absolutes? It's not a web project though so I didn't even know this
was necessary. What happened is that I created this project consisting
of several worksheets using external data ranges to get data from each
other. I created it on our server at work, burned it to a cd and took
it home to work on. At home the files won't refresh data because
they're looking for data that can't be found - even though its all on
the cd. The filename it looks for however has the entire path to my
server. I need this to be portable so I can just zip it all up and
hand it over to the group that will use it and the folders should be
able to refresh data and work independently. Is there something I need
to do? I didn't hard code the path in there, just set my links as
normally...
Click to expand...

Bad news. Excel supports only full (absolute) pathnames. There are tricks you
could play using Auto_Open macros or [Workbook] Open event handlers that would
change all link locations based on the full pathname of the first opened file.
Are you looking for a macro solution? If you want to avoid VBA, you're out of
luck.
 
Back
Top