| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change the default caption of a workbook to the full pathname? | Excel Programming | |||
| How do use listed pathname to link values from another workbook? | Excel Discussion (Misc queries) | |||
| Using a variable name as part of a file pathname to open many files | Excel Programming | |||
| Extract Workbook name from pathname ? | Excel Programming | |||
| LoadPicture Pathname or no Pathname | Excel Programming | |||
Hybrid Mode
