Hi all!

Long time Excel/Word linking geek, first time poster.  Graham Mayor turned
me on to this NG.

Q:  Is there a way around using the full path in my links?  I run everything
across a server, so the full path usually ends up being a monsterous thing
like ////pbw_dc1//vol1//data//jobs//7000s//7065JobFolder/blank.gif just to
get an if/then/else includepicture to post a blank pixel if the condition
isn't met.

The problem comes in when I (or somebody else...) uses a mapped drive "J:"
to open excel and/or word.  For some reason, the mapping puts the full path
in title case, whereas the original/existing links are all in lower case.
If somebody makes a new paste special link after having opened it up from J:
[which dumps straight into 7000s until 7000s is full, then J: => 7100s,
etc.], it will have links with lower case and links with upper case.  This
inevitably crashes links and gives me errors...

Seems like you could just say something to the effect of "/" to designate
that it is coming from the current folder, but I don't know.

Thanks for the help.  This won't be my last question.  ;-)

Andy