Relative link

  • Thread starter Thread starter Bob Mc
  • Start date Start date
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
 
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?
 
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
 
...
...
Could you give me an example of what you mean by OS trickery. How would I
go about mapping this path?
Click to expand...
...

If you don't have a Q: drive, then the 'net use' command could be used to map Q:
to any Windows network share, and 'subst' could be used to map Q: to any
directory on your own machine. I'm assuming you're using Windows NT, 2000 or XP.
If you're using Windows 95, 98 or Me, there may be equivalents, but I don't know
them (perhaps subst.exe comes with those versions, but I doube net.exe does).
Both net and subst commands, if available, are documented in the Windows help
files.
 
I use win98 and I shelled to a DOS prompt and did:

net use /h

And got this:

Connects or disconnects your computer from a shared
resource or displays information about your
connections.

NET USE [drive: | *] [\\computer\directory [password | ?]]
[/SAVEPW:NO] [/YES] [/NO]
NET USE [port:] [\\computer\printer [password | ?]]
[/SAVEPW:NO] [/YES] [/NO]

NET USE drive: | \\computer\directory /DELETE [/YES]
NET USE port: | \\computer\printer /DELETE [/YES]
NET USE * /DELETE [/YES]

......

And this for Subst:

Associates a path with a drive letter.

SUBST [drive1: [drive2:]path]
SUBST drive1: /D

drive1: Specifies a virtual drive to which you want to assign a path.
[drive2:]path Specifies a physical drive and path you want to assign to
a virtual drive.
/D Deletes a substituted (virtual) drive.

Type SUBST with no parameters to display a list of current virtual drives.
 
Back
Top