Relative link

B

Bob Mc

Is it possible to have relative links, as opposed to absolute links when
linking to an Excel spreadsheet in another application?

Bob Mc
 
H

Harlan Grove

Bob Mc said:
Is it possible to have relative links, as opposed to absolute links when
linking to an Excel spreadsheet in another application?
Click to expand...

Not possible in Excel itself. You could use OS trickery, mapping a drive on
an ad hoc basis to the current location needed. But what do you mean by
another application?
 
B

Bob Mc

Harlan,

Sorry I wasn't very clear with my question. By "another application" I was
referring to CAD files that I inserted the Excel spreadsheet into using OLE.

Could you give me an example of what you mean by OS trickery. How would I
go about mapping this path?

Thanks,

Bob
 
Top