How to references objects that exist on local or network drives that aren't open.
 

What vba code can reference objects, Range objects in particular, in
workbooks that aren't open?

This is accomplished with Quick Links in Excel... But I can't seem to find a
method in VBA.

I want to do something like this:

Sub MySub()

Public MyVar, LocalWorkbok as Workbook
Set LocalWorkbook = "F:\Database.xls"

MyVar = LocalWorkbook.Find(Etc...)

End sub


But obviously that doesn't work.

Mike-hime