How to get application shortcut to work with different drive mappi

[Guest]

Hello,

I have an Excel spreadsheet that I want to share with the office, and some
of the people who will be using it are not very computer savvy. So I want to
create a shortcut that will work on ANY workstation that is connected to the
SAME server where the Excel file will be kept. The problem is that many of
the workstations are not mapped to the server in the same way, i.e.
workstation "A" is showing a drive letter such as M:\ that is mapping to the
server, whereas workstation "B" is using letter E:\. If it is relevant, from
my workstation, the Excel file path is X:\Data\2006\LA\Status.xls.

How can I make it so that ANYONE will be able to access the file w/o any
glitches? It needs to work the FIRST time I roll it out, otherwise they will
not want to fool with it, as we are all very busy, and what they will end up
doing (which is what I DON'T want to happen) is asking me to email them the
file then copying it to their personal folder.

Although it's SOT, I'd like to add that the Excel file is SHARED workbook
file. If anyone has any cautionary advice with regard to using that type of
workbook file, I'm welcoming your input in any case.

Thanks in advance for your replies.

Phil.

 

[Pegasus \(MVP\)]

Hello,

I have an Excel spreadsheet that I want to share with the office, and some
of the people who will be using it are not very computer savvy. So I want to
create a shortcut that will work on ANY workstation that is connected to the
SAME server where the Excel file will be kept. The problem is that many of
the workstations are not mapped to the server in the same way, i.e.
workstation "A" is showing a drive letter such as M:\ that is mapping to the
server, whereas workstation "B" is using letter E:\. If it is relevant, from
my workstation, the Excel file path is X:\Data\2006\LA\Status.xls.

How can I make it so that ANYONE will be able to access the file w/o any
glitches? It needs to work the FIRST time I roll it out, otherwise they will
not want to fool with it, as we are all very busy, and what they will end up
doing (which is what I DON'T want to happen) is asking me to email them the
file then copying it to their personal folder.

Although it's SOT, I'd like to add that the Excel file is SHARED workbook
file. If anyone has any cautionary advice with regard to using that type of
workbook file, I'm welcoming your input in any case.

Thanks in advance for your replies.

Phil.

Use UNC coding: \\YourServer\SomeShare\Data\2006\LA\Status.xls.
Make sure to test it before you roll it out.

 

[Guest]

OK. Now I'm going to ask a dumb question, but bear with me. How can I find
the "Absolute" correct name of the server? I am on an XP workstation, if
that helps.

 

[Guest]

Never mind, I figured it out.

Thanks for your help!