I'm almost there, but I just can't get it quit right. I am try to get a
value from a cell using the full path to the file. This ain't working, but
it's close. What am I doing wrong?

Sub Test()
pName = "U:\ExcelFiles\ADI-JournalEntries\Current_Month\Advance-O&M_Cur.xls"
MsgBox pName & Sheets("Journal1").Range("R22")
End Sub