macro to display UNC path

[Faridwahidi]

Hi,

Can anyone help me to provide VBA code to display UNC path \\servername\sharename\path\filename

I only know the code for normal path msgbox thisworkbook.fullname



Regards,
Farid

[TKCZBW]

Please Login or Register  to view this content.

That gives me the full path, hope it helps.

[Trebor76]

Hi Faridwahidi,

As long as the workbook has been saved, this should do the trick:

Please Login or Register  to view this content.

HTH

Robert

[Faridwahidi]

Hi,

This is not UNC path. \\servername\sharename\path\filename


That path can be easily obtained by using these methods

1. Formula =SUBSTITUTE(LEFT(CELL("filename",A1),FIND("]",CELL("filename",A1))-1),"[","")

2. or just Add Document Location in quick Access Toolbar.

[Faridwahidi]

Hi Trebor76,


That is what I want. thanks a lot

Regards,
Farid

[TKCZBW]

Certainly when I run it, it does give all that information. You must of course (as Trebor76 said above) run it on a saved workbook however.
If you want to exclude file name jusr use:

Please Login or Register  to view this content.

instead of .fullname

[Faridwahidi]

Hi,

my 1st comment refer to TKCBZW reply

[TKCZBW]

I know this is marked as solved, but I just stumbled across this link which may provide a little more colour:

http://support.microsoft.com/kb/160529