Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Window ("****.xls").Activate
I would like to know how to us a named range to provide
the file name vs. hard coding the file name. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Window ("****.xls").Activate
sFile = Range("myWorkbook")
Workbooks.Open Filename:= sFile etc. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Robert" wrote in message ... I would like to know how to us a named range to provide the file name vs. hard coding the file name. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Activate "Show all" in a Protected Shared Workbook | Excel Discussion (Misc queries) | |||
How can I "re-hook" my worksheet window to my Excel window? | Excel Discussion (Misc queries) | |||
How can I "re-hook" my worksheet window to my Excel window? | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
freeze window creates multiple "views" suffixed with ":n" | Excel Discussion (Misc queries) |