Thread: Open a workbook in VBA using UNC pathname
View Single Post
  #1   Report Post  
Tom Wikle Tom Wikle is offline
Junior Member
  
Posts: 1
Default Open a workbook in VBA using UNC pathname
In VBA I need to open a workbook using the UNC pathname. Right now the code is:
mfdate = FileDateTime("HG Equipment Tracking Matrix.xls")

I need to add the UNC pathname to the file name. Nothing seems to work. The UNC pathname is:
\\beavertn-nas-06\twikle\

What is the right code to make this work?
Reply With QuoteReply With Quote