Discussion:
Absolute vs Relative references
(too old to reply)
David
2010-11-02 13:29:37 UTC
Permalink
Hi, I hope somebody can help. I have an application that has been
built in WSS, at point in the use of the application a new site is
created, within that site I have a template (Excel) sitting in a
document library. I can open the Excel workbook from within the site
and record a macro that saves that excel workbook back into the
document library where the excel workbook was opened from as a .csv
file, all good so far. The macro includes and absolute path to where
the .csv file should be created and therefore if I run the macro from
an Excel workbook that resides in a different site it attempts to
place the .csv in that absolute path, the one that was referenced when
creating the macro and not the one where the workbook is now being
opend from and where the .csv extract needs to go. I need to modify
the macro so that it creates / saves the .csv in the location from
which the excel workbook was opened, regardless of where it is
sitting. So currently the path where it saves (copied from the
recorded macro) is as follows;

"http://redtree01:90/Products/7/Product Plans/Product
Rollout.csv",

I need to change it to "http://redtree01:90/location where the
currently open workbook resides/Product Rollout.csv",

As may be obvious I have no previous experience in this, the answer, I
am assuming, is a simple one?
P E
2011-07-11 06:40:04 UTC
Permalink
Sorry but still not possible. I wish MS would enable this feature. Sheets with loads of references to e.g. underlaying forrest of sheets cannot be moved without loads of work to manually change the links.
Post by David
Hi, I hope somebody can help. I have an application that has been
built in WSS, at point in the use of the application a new site is
created, within that site I have a template (Excel) sitting in a
document library. I can open the Excel workbook from within the site
and record a macro that saves that excel workbook back into the
document library where the excel workbook was opened from as a .csv
file, all good so far. The macro includes and absolute path to where
the .csv file should be created and therefore if I run the macro from
an Excel workbook that resides in a different site it attempts to
place the .csv in that absolute path, the one that was referenced when
creating the macro and not the one where the workbook is now being
opend from and where the .csv extract needs to go. I need to modify
the macro so that it creates / saves the .csv in the location from
which the excel workbook was opened, regardless of where it is
sitting. So currently the path where it saves (copied from the
recorded macro) is as follows;
"http://redtree01:90/Products/7/Product Plans/Product
Rollout.csv",
I need to change it to "http://redtree01:90/location where the
currently open workbook resides/Product Rollout.csv",
As may be obvious I have no previous experience in this, the answer, I
am assuming, is a simple one?
Continue reading on narkive:
Loading...