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
Dave Peterson - 31 Jul 2004 13:00 GMT
You have one reply at one of your other posts.
It's not necessary to multipost to lots of newsgroups. If you feel the need to,
then post one message to all your chosen groups (called cross posting).
Then each followup should appear in each group. It'll make your life
easier--you won't have to check several newsgroups for the best answer, you
might get a better answer if someone enhances a possible solution and it won't
waste the responder's time for posting something that's already been posted.
> Hi
>
[quoted text clipped - 19 lines]
> Thanks
> Carlos

Signature
Dave Peterson
ec35720@msn.com