Get Network Computer Name

[TimTDP]

I have code that returns the url of a file as follows:
"S:\Documents\Database.accdb"

"S" is a mapped drive

I want to use the computer's name rather than the mapped drive, i.e:
"\\ComputerName\Documents\Database.accdb"

How do I return the name of the computer?

Many thanks

 

[mdlueck]

How do I return the name of the computer?

Here you go...
http://vbadud.blogspot.com/2007/05/get-computer-name.html

 

[TimTDP]

That will give me my computer's name

I need the name of the network computer that a file resides on.
My computers name is "Frank" and I have a mapped drive "S" to computer "Joe"

I have vba code that allows my to navigate files like Windows File Explorer

If I point to a file on Joe's computer I want to store it as "\\Joe\Documents\FileName

 

[PeterF]

This Microsoft KBn article gives the sample code you need.

 

[TimTDP]

thanks very much