Workbooks.opentext Filename:= Activesheet.Range("B2").Value

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"rickey24 " wrote in message
...
Hi

If you have the whole file path name (eg.
C:\Pen\Data\Worlds\Global.xls) in Excel Cell B2, how do you call that
in my macro with, for e.g.
Workbooks.opentext Filename:= B2. Is that possible? Thanks.

RH


---
Message posted from http://www.ExcelForum.com/