View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
[email protected] koroth112@gmail.com is offline
external usenet poster
 
Posts: 1
Default getting a message box with the unc file path

I need help getting a message box with a unc file path to pop up(ie. \
\server1\folder1\file1)
my current code is
Sub whatisfilepath()

MsgBox ActiveWorkbook.Path

End Sub

i need to know if it is possable to have a unc file path
any help is good help.