When using the =Cell("filename") function, I would like to show the actual
server instead of a drive letter because the letter is dependent on where the
server is mapped and not all users have the same mapping. Is this possible?

Try using:
\\ServerName\drive\...
where ServerName is the name of the server and drive is the appropriate
drive, and then find the file on the drive from that point.

"bfant" wrote:

When using the =Cell("filename") function, I would like to show the actual
server instead of a drive letter because the letter is dependent on where the
server is mapped and not all users have the same mapping. Is this possible?

And you may want to make your formula look more like:

=cell("filename",a1)

Otherwise, your formula will evaluate to the last workbook that was calculated.

You can see this if you have the same formula in A1 of sheet1 of two separate
workbooks.

Window|arrange|horizontal

(Save both workbooks and look at each of the cells after each save.)

bfant wrote:

When using the =Cell("filename") function, I would like to show the actual
server instead of a drive letter because the letter is dependent on where the
server is mapped and not all users have the same mapping. Is this possible?

--

Dave Peterson

I know my original question was vague, so let me be a bit more specific.
When using =cell("filename",a1), the cell will display something like:
(G:\Folder[File]Worksheet.xls )
Instead of the drive letter, which can have any server mapped to it, I would
like the actual server name. I know this can be done using macros, but I
would like to know if there is a formula or add in that will do the same
thing.

"Dave Peterson" wrote:

And you may want to make your formula look more like:

=cell("filename",a1)

Otherwise, your formula will evaluate to the last workbook that was calculated.

You can see this if you have the same formula in A1 of sheet1 of two separate
workbooks.

Window|arrange|horizontal

(Save both workbooks and look at each of the cells after each save.)

bfant wrote:

When using the =Cell("filename") function, I would like to show the actual
server instead of a drive letter because the letter is dependent on where the
server is mapped and not all users have the same mapping. Is this possible?

--

Dave Peterson

Did you try Chad's suggestion of opening the file by traversing the UNC
path--not the mapped drive?

(I don't have a network to test it on.)

bfant wrote:

I know my original question was vague, so let me be a bit more specific.
When using =cell("filename",a1), the cell will display something like:
(G:\Folder[File]Worksheet.xls )
Instead of the drive letter, which can have any server mapped to it, I would
like the actual server name. I know this can be done using macros, but I
would like to know if there is a formula or add in that will do the same
thing.

"Dave Peterson" wrote:

And you may want to make your formula look more like:

=cell("filename",a1)

Otherwise, your formula will evaluate to the last workbook that was calculated.

You can see this if you have the same formula in A1 of sheet1 of two separate
workbooks.

Window|arrange|horizontal

(Save both workbooks and look at each of the cells after each save.)

bfant wrote:

When using the =Cell("filename") function, I would like to show the actual
server instead of a drive letter because the letter is dependent on where the
server is mapped and not all users have the same mapping. Is this possible?

--

Dave Peterson


--

Dave Peterson

I do not want to open the file, instead I want to show the filename when the
file is printed (except instead of the drive letter, I want to see the
server). I have used macros to do this in the past, but I do not want to
have to do this in the future.
"Dave Peterson" wrote:

Did you try Chad's suggestion of opening the file by traversing the UNC
path--not the mapped drive?

(I don't have a network to test it on.)

bfant wrote:

I know my original question was vague, so let me be a bit more specific.
When using =cell("filename",a1), the cell will display something like:
(G:\Folder[File]Worksheet.xls )
Instead of the drive letter, which can have any server mapped to it, I would
like the actual server name. I know this can be done using macros, but I
would like to know if there is a formula or add in that will do the same
thing.

"Dave Peterson" wrote:

And you may want to make your formula look more like:

=cell("filename",a1)

Otherwise, your formula will evaluate to the last workbook that was calculated.

You can see this if you have the same formula in A1 of sheet1 of two separate
workbooks.

Window|arrange|horizontal

(Save both workbooks and look at each of the cells after each save.)

bfant wrote:

When using the =Cell("filename") function, I would like to show the actual
server instead of a drive letter because the letter is dependent on where the
server is mapped and not all users have the same mapping. Is this possible?

--

Dave Peterson


--

Dave Peterson

Don't you have to open the file to print it?

If you just rightclick, Print (from Explorer), make sure you're looking at the
file via the UNC path.

bfant wrote:

I do not want to open the file, instead I want to show the filename when the
file is printed (except instead of the drive letter, I want to see the
server). I have used macros to do this in the past, but I do not want to
have to do this in the future.
"Dave Peterson" wrote:

Did you try Chad's suggestion of opening the file by traversing the UNC
path--not the mapped drive?

(I don't have a network to test it on.)

bfant wrote:

I know my original question was vague, so let me be a bit more specific.
When using =cell("filename",a1), the cell will display something like:
(G:\Folder[File]Worksheet.xls )
Instead of the drive letter, which can have any server mapped to it, I would
like the actual server name. I know this can be done using macros, but I
would like to know if there is a formula or add in that will do the same
thing.

"Dave Peterson" wrote:

And you may want to make your formula look more like:

=cell("filename",a1)

Otherwise, your formula will evaluate to the last workbook that was calculated.

You can see this if you have the same formula in A1 of sheet1 of two separate
workbooks.

Window|arrange|horizontal

(Save both workbooks and look at each of the cells after each save.)

bfant wrote:

When using the =Cell("filename") function, I would like to show the actual
server instead of a drive letter because the letter is dependent on where the
server is mapped and not all users have the same mapping. Is this possible?

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson