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

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