Window ("****.xls").Activate

R

Robert

I would like to know how to us a named range to provide
the file name vs. hard coding the file name.

Thanks
 
B

Bob Phillips

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)
 
Top