howto send data from vb to excel for printing

[sanamsalehi]

Hi
I want to send data from vb (msflexgrid) to excel . buto I dont know how .
can anyne help me?

[Killer42]

Hi
I want to send data from vb (msflexgrid) to excel . buto I dont know how .
can anyne help me?

One way is to add the Microsoft Excel Object Library to the list of References in your project. Look up the documentation on the Excel object - it's quite easy to drive Excel from your VB code.

[deco]

After you added the Microsoft Excel Object Library to the list of References in your project try write this code:

 
Dim xlApp As New Excel.Application
Dim xlwk As New Excel.Workbook
 xlApp.Interactive = True
 
 Set xlwk = xlApp.Workbooks.Open(App.Path & "\test.xls")  '(test.xls) file already exist in the application folder
 
 xlApp.Cells(1, 1) = 1982    'send the value or object or string  to excel
 
 xlApp.Columns.AutoFit
 xlApp.Visible = True
 ' xlwk.Save
 ' xlApp.Quit
 

[Killer42]

After you added the Microsoft Excel Object Library to the list of References in your project try write this code:
...

Thanks deco. I'm afraid I was being a bit lazy.