Reading from Closed Workbook Using Network Path

[TripJJJ]

Hello Experts!

I'm having some trouble reading information from a closed workbook on a network drive. The problem seems to be caused by using the full drive path. When I tried using the drive letter (i.e. X:\Folder\File), it works. The problem is that each user can map to a different drive letter, so I wanted to use the full path name.

If I enter the path directly into a cell (instead of going through VBA), it opens an 'open file' dialogue box, instead of returning the value.

Code Snip
Dim arg As String
arg = "='\\SERVER\Folder1\Folder2\[LatestVersionFile.xlsm]Sheet1'!$A$1"
Result = ExecuteExcel4Macro(arg)

So it works using the drive letter, but not the network path name??

Using Excel 2010...

Any help is appreciated!!!!

 

[TripJJJ]

Hi All - Any ideas on this one? Is this even possible?