Re: Can I show server name instead of drive letter?
From: Dave Peterson (ec35720_at_netscapeXSPAM.com)
Date: 02/15/05
- Next message: Dab: "Help: Scroll wheel toggles between up and down, and left and right - is driving me crazy"
- Previous message: Terminatrix: "intellimouse gone dirty-boy; restore backspace on outer left ***."
- In reply to: bfant: "Can I show server name instead of drive letter?"
- Next in thread: bfant: "Re: Can I show server name instead of drive letter?"
- Reply: bfant: "Re: Can I show server name instead of drive letter?"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 14 Feb 2005 19:10:25 -0600
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
- Next message: Dab: "Help: Scroll wheel toggles between up and down, and left and right - is driving me crazy"
- Previous message: Terminatrix: "intellimouse gone dirty-boy; restore backspace on outer left ***."
- In reply to: bfant: "Can I show server name instead of drive letter?"
- Next in thread: bfant: "Re: Can I show server name instead of drive letter?"
- Reply: bfant: "Re: Can I show server name instead of drive letter?"
- Messages sorted by: [ date ] [ thread ]