On 3 Sep, 16:14, Mike H wrote:
Hi,

Maybe if you define the sheet you want

MyVal = ActiveWorkbook.Sheets("Sheet2").Range("a1").Value

Mike

"Raj" wrote:
Hi,

I opened a comma separated text file in vba by first recording a
macro.When I run the macro the import of the values happens as
expected.

When I activate the Workbook and type "?Activeworkbook.name" in the
Immediate window, it shows the name of the workbook. However, when I
type "?Activeworkbook.Range("a1").value", it returns Error 438 "Object
doesn't return this property or method". I need to read the values in
the imported workbook. Please help.

Thanks in Advance for the Help.

Regards,
Raj

Hi Patrick/Mike,

Thanks a ton. Was missing the obvious :)

Regards,
Raj