Hi

Im writing a vba program to take the info from an asc file into
sheet2. I must use the xldelimited so the info goes into each column
properly and not just everything in one column ( it uses the comma to
determine the column).

The intention of the program is, in sheet1, a command button is used
to open a file window. The asc file is then selected bu the user, and
the data is to placed into sheet2. The asc file is no longer needed.
Calculations are made and shown in sheet1 using the data in sheet2.

The problem is Im not sure what function to use. Im thinking this
one:

object.OpenAsTextStream([iomode, [format]])

but cant get the above to work, because not too familiar with vba and
need help. The excel help example doesnt real show me.
Is there a website that has simple examples?

Thanks
Carlos