Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mapped vs Network drives | Excel Worksheet Functions | |||
Hyperlinking on Network drives | Excel Worksheet Functions | |||
Network Drives | New Users to Excel | |||
Excel files on local drives running from internet | Excel Worksheet Functions | |||
Network drives | Excel Programming |