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