ExcelBanter - Open a workbook in VBA using UNC pathname

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Open a workbook in VBA using UNC pathname (https://www.excelbanter.com/excel-programming/447407-open-workbook-vba-using-unc-pathname.html)

Tom Wikle

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?

All times are GMT +1. The time now is 01:43 PM.