I have to develop a code with visual basic to open a file then read each line of the text file one string at a time then output these strings to individual cells in excel.
Can anyone help?
rejina
0
Newbie Poster
Recommended Answers
Jump to Post>open an unknown file with Visual Basic
Open statement.
Jump to PostAs adatapost pointed out, you need to look up the following in help or online...
FreeFile Function
Open Statement
Line Input Function
Close StatementThen, use your friends (yahoo, google, ask, answers, bing) and search for vb6 excel tutorial or vb6 automating excel...
Edit: Also while …
All 7 Replies
kvprajapati
1,826
Posting Genius
Team Colleague
vb5prgrmr
143
Posting Virtuoso
kvprajapati
commented:
Helpful!
+9
AndreRet
526
Senior Poster
rejina
0
Newbie Poster
vb5prgrmr
143
Posting Virtuoso
WaltP
2,905
Posting Sage w/ dash of thyme
Team Colleague
vb5prgrmr
143
Posting Virtuoso
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.