VBA Reference correctly

[MikeDBMan]

I know this works when I am in the file I from which I wish to retrieve the info:

Let ThePath = Sheets("intParam").Range("ThePath").Value

But if I am not in the correct file, what is the syntax. This does NOT work:

Let ThePath = windows.("Projects.xlsm").Sheets("intParam").Range("ThePath").Value

 

[mvptomlinson]

Instead of "Windows" try "Workbooks" and put the full path to the workbook if it is in a different folder than the workbook you're referencing it from.