Help with delimited text files
 

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

Help with delimited text files
 

You should give also worksheet object, try:
?Activeworkbook.ActiveSheet.Range("a1").value

Regards,
Stefi

€žRaj€� ezt Ã*rta:

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

Help with delimited text files
 

double posting - please refer to earlier query with same subject

"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