M
Mike-hime
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
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