View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Raj[_2_] Raj[_2_] is offline
external usenet poster
 
Posts: 150
Default 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