Macro to Put network path in cell

K

K

Hi all, The Macro below put path in cell A1 which is "F:\Documents\Data
\Record.xlsx"

Sub getpath()
Range("A1").Value = ThisWorkbook.FullName
End Sub

I work in office and we save everything on network drive. The above
file or path is actually in "\\Home\Trader\Documents\Data
\Record.xlsx". Please can any friend can help that how can I make
appear network path instead of drive path in cell A1. I tried code
below to achive what i want but there must be some way in excel vba to
get network path by code.

Sub getpath()
Range("A1").Value = "\\Home\Trader" & Right(ThisWorkbook.FullName, Len
(ThisWorkbook.FullName) - 2)
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top