Excel/Word 2k3 Web Address Bar selection expands to UNC 2

[JPJeffery]

Hi

Imagine you have a G: drive mapped to \\server\groups.

Now, enable the 'Web' toolbar.

Now use the toolbar to pull down the list of drives, paths and URLs and select the G: drive.

When the Explorer window opens it's expanded to the full UNC path of \\server\groups instead of the mapped drive letter G:\.

Is there a way to change this behaviour to open the mapped drive? I've not found anything in Tools -> Options

JJ
[small][purple]Variables won't. Constants aren't[/purple]
There is no apostrophe in the plural of PC (or PST, or CPU, or HDD, or FDD, or photo, or breakfast...and so on)[/small]

 

[JPJeffery]

...I take that as a no then.

Stupid Microsoft.

JJ
[small][purple]Variables won't. Constants aren't[/purple]
There is no apostrophe in the plural of PC (or PST, or CPU, or HDD, or FDD, or photo, or breakfast...and so on)[/small]

 

[xlhelp]

I have not looked at it in detail, but Karl Petersen has info on this kind of stuff on his wesite:

http://vb.mvps.org

Also, searching for "mapped drive unc path" yielded some results about what you are asking. You need to weed out what you don't need. Since I don't need to go that "path", I haven't read through them

Canadian eh! Check out the new social forum Tek-Tips in Canada.
With the state of the world today, monkeys should get grossly insulted when humans claim to be their decendents

 

[SkipVought]

Just as a matter of practice, I would MUCH rather have the full UNC, since I deal with many users in my organization, and user A's Z: drive is not necessarily mapped identically as my Z: drive.

So I ALWAYS prefer and use UNCs!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[JPJeffery]

Ta muchly.

JJ
[small][purple]Variables won't. Constants aren't[/purple]
There is no apostrophe in the plural of PC (or PST, or CPU, or HDD, or FDD, or photo, or breakfast...and so on)[/small]

 

[JPJeffery]

SkipVought : Me too, but this isn't so easy for end users.

Also, what has prompted the question is a query from a colleague who's trying to put together some documentation with screenshots and the UNC path doesn't display completely within the text field he's illustrating. It's just causing confusion.

JJ
[small][purple]Variables won't. Constants aren't[/purple]
There is no apostrophe in the plural of PC (or PST, or CPU, or HDD, or FDD, or photo, or breakfast...and so on)[/small]

 

[SkipVought]

Educate your end users up to a standard, rather than dumbing down to the lowest common demoninator, (which seems to have been the strategy for US education over the past several decades; don't know about GB, however).

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[JPJeffery]

Dahling, they're FAR to busy doing IMPORTANT stuff instead of learning other stuff that they see as 'doing IT' even though that would actually HELP them do THEIR jobs better...

Case in point: I created URLs for our Hong Kong users to connect to some virtual machines we have here in London so that they can reboot the VMs should anything go wrong with them. I wrote up some instructions in a beautifully presented PDF, complete with screenshots, to make it as easy as possible.

The email I sent to let them know about the document and process never even got read by most of them.

Sure enough, one of the machines hung (a Windows problem, of course) and the HK user of that VM waited until we got in to the office about eight hours later before getting us to fix it for him. No doubt huffing and puffing about useless IT systems while he was waiting.

In other words, he'd rather go without the functionality of that PC and the system it runs for most of a full working day, than try and fix it himself.

SELECT * from USERS where CLUE > 0
0 rows returned

JJ
[small][purple]Variables won't. Constants aren't[/purple]
There is no apostrophe in the plural of PC (or PST, or CPU, or HDD, or FDD, or photo, or breakfast...and so on)[/small]