Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2004

Tip: Looking for answers? Try searching our database.

Which function to use to open an .asc file?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Real Name - 31 Jul 2004 04:33 GMT
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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.