Hi Folks

I have 2 Excel file(s)
File 1: ConnectionString.xls
This has a worksheet : GlobalConnString
In this worksheet, I have a TEXT value defined in the cell A1

File 2: MyReport.xls
This has a worksheet : Report-1

Requirement
========
Using VBA Code, I want to read the value in this worksheet from the file
<File1.<Worksheet1.<Cell1
<ConnectionString.xls.<ConnString.<A1
Is this possible?
If so, could somebody please let me know how?

Thanks
PP