[RESOLVED] Inserting data from VB into Excel.??? Need help!

[Hamsori]

Hi!

I'm trying to find an easy way to export data from my database using VB.
I already managed to write some textbox values into excel, but since this takes a lot of time and is not practical in my program, I need to learn how to export masses at a time...

So, I need to write 6 different values from the database table (shown in the picture in red) that are decided by 3 other values (shown in the picture in blue).

I have a Form1 where I can choose the "ProjHenkID", "TyöNro" and "Pvm:" (shown in blue)...


Started the code like:

Dim MyExcel As New Excel.Application
        MyExcel.Workbooks.Open("C:\Tuntilappu.xls")
        MyExcel.Visible = True

but don't know how to call values from the database and insert them into specific cells in Excel...