Saving data from visual basic 6 to an excel file

[Hema Suresh]

Hi this is Hema

I took a journey on learning Visual Basic 6

I want to save data in a visual basic form to an Excel file in a neat and tabulated format

Ex : I have two text boxes which gives the details about the user such as

Text Box 1 : Name
Text Box 2 : Job Designation

I can move the data to a normal Text file using "Open, Write, Close" file commands

But in case of Excel file,i dont get any idea

When i searched in forums, i can get the codes for my problem

But i dont feel comfortable because i cant understand the code in-depth

So please can anyone suggest me some good books or tutorials or websites to learn the concept of "Saving the data from visual basic form to an Excel file"

I feel much helpfull if i get a solution
Thank you

[Killer42]

VB can work directly with Excel files, in a couple of ways. However, for this sort of output you may find the simplest thing is just to write out a text file as you've tried, but with the data in CSV (Comma Separated Values) format, and with an extension of csv instead of txt.

CSV format is quite simple to write, as well. You simply put commas between the fields. If a field contains either commas or quotes (") you put quotes around it, and double the quotes within the data. For example a field with the admittedly rather odd value of
abc,d"efg
would become
"abc,d""efg"

Any time you're not sure about exactly how to write something to a CSV file, I recommend you just put that value in a spreadsheet in Excel, then use Save As and select CSV format. That way Excel itself can show you how it wants the data formatted.

[Hema Suresh]

Thank u sooooo much
i tried it

ya it is successfull

i can move the data from visual basic to an excel file

but i have lot many doubts regarding this

At present, I have the following doubts

If i have many datas with me like Name, Designation, Age, etc.., I need to move all the datas in a tabulated way to an excel file

I need the data to be placed in a specified cell of an Excel file

I may rising so many doubts regarding this
So I feel better if i get any good books to learn how to make things possible

Please suggest me some good books or tutorials or websites to learn
"Detailed study about moving data from a visual basic form to an Excel file"

Thank You so much for your kind answers

[Killer42]

I don't know of any. What I'd suggest for this is to hit Google with the key words of your query. It should find you plenty of tutorials and the like.

[Hema Suresh]

I gained much in google
Thank u