Network drive letter designation and links in Excel 1

[vladk]

Hi,

I added a reference to second workbook in the first workbook in some formula. Then I closed the workbooks and opened the first one. The formula in the cell contains link in this form:

H:\Prop\Spec\...

I,instead, need this:

\\mynetwotk\Prop\Spec...

How to do this?

Thank you

vladk

 

[RonRepp]

Like this:

='\\MyNetwork\shared\Prop\Spec\WorkbookName'!$Q$5

I hope his helps.

Ron

Note: If there is a space in the workbook name, you must enclose it in brackets.

Ron Repp

 

[vladk]

RonRepp,

Exactly, but how to do this BY DEFAULT???

I do not want it to do neither with my hands nor through the macro. I want Excel do it for me instantly each time when I refer to the workbook on the network.

vladk

 

[RonRepp]

Now that's a good question.

I looked up links in the help section, but I don't think this is what you want. Doing it through code would be the way that I'd go, but...

Using links, I was able to place an entire spreadsheet as an object, but not an individual cell.

Sorry I couldn't help more.

Ron



Ron Repp

 

[rmikesmith]

vladk,

I do not want it to do neither with my hands nor through the macro. I want Excel do it for me instantly each time when I refer to the workbook on the network.

Don't you know by now that Excel (Microsoft) doesn't care what you want?

Seriously, though, you may want to check out this link, where the author describes a similar problem as well as a solution (which you also may not like):

http://www.dicks-blog.com/archives/2006/02/12/hyperlinks-and-network-shares/

Regards,
Mike

 

[PHV]

I added a reference to second workbook in the first workbook in some formula
How you did that ?
I guess if you don't have mapped drive then excel keeps the UNC, doesn't it ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[vladk]

rmikesmith,
Thank you for the interesting link but I want the opposite thing - not to use letter in formulas since different PCs have different letter network drive designations: I need UNC by default.

PHV,
In the cell of the first wbook, I typed "=", selected another cell in the second wbook, and hit Enter.
I have to refer to the mapped drive.

vladk

 

[PHV]

I have to refer to the mapped drive
???

 

[vladk]

PHV,
Sorry for the confusion, I mean, the same network drive has different letters on different PCs.
vladk

 

[PHV]

In the cell of the first wbook, I typed "=", selected another cell in the second wbook, and hit Enter
And what happens if the second wbook was open with UNC instead of mapped drive?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[vladk]

PHV,

May be I am missing something...
The people who open the Excel wbook, they just double click on the file name in the Explorer. How this procedure relates to the ability to choose UNC instead of the mapped drive?

vladk

 

[PHV]

Browse Network Neighborhood instead of My Computer.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[vladk]

PHV,

Great!
Thank you.

vladk