After saving the information in my database i want to print the information using the excel which has a layout, how im going to connect my excel to my database

like example

lnametxt.text = A1 in my excel how to do that

Hi
Google for "Automating Excel using VB" and work from there.
Also, this appears to be a duplicate post from http://www.andreavb.com/forum/viewtopic.php?TopicID=8118&page=0#26616

In essence:
Create a project
Add a reference to Microsoft Excel Object Library
The code below creates a new workbook and puts data into it

public sub ExcelDemo() dim objApp as excel.application dim objWB as excel.workbook dim objWS as excel.worksheet ' Connect to excel set objapp = new excel.applcation ' Create a new workbook set objwb = objapp.workbooks.add() ' Create a new worksheet set objWS = objwb.worksheets.add("funkytest") ' Update some text dim objRange as excel.range set objrange = objWS.Range("A1") objrange.value = "34.565" ' close excel without saving set objws = nothing objWB.close false objApp.quit end sub

Hope it helps
Kieron


[Edited by stickleprojects on 04-02-2008 at 07:41 AM GMT]

____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)

Oh yes.
To get more code.
Record a macro in Excel and study the code


____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)