Relative link
Bob Mc wrote:
Using OLE, where an Excel spreadsheet cell range is the source, is it
possible to specify a directory path as a relative link as opposed to an
absolute link.
If you are talking about formula links from one Excel cell to another,
they are, in effect, always held as relative links if the two files are in
the same directory or related directories on the same drive.
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
|