how to connect excel to vb

[giriab]

hi i have written one progrm in vb but i want its output in excel but i am not able to coonect excel to vb so plz help me

[Killer42]

hi i have written one progrm in vb but i want its output in excel but i am not able to coonect excel to vb so plz help me

You need to add Microsoft Excel n.n Object Library in your project references.

[SammyB]

hi i have written one progrm in vb but i want its output in excel but i am not able to coonect excel to vb so plz help me

Which VB? VBA (which application), VB6, or VB.NET? Do you want to use ADO or access Excel directly?

[giriab]

Which VB? VBA (which application), VB6, or VB.NET? Do you want to use ADO or access Excel directly?

vb6 and i want to access excel directly

[giriab]

You need to add Microsoft Excel n.n Object Library in your project references.

how to add the object library

[SammyB]

how to add the object library

No VB6 here, but it maybe the Tools, References menu. Maybe even Ctrl R. In any case, it's the References or Add References menu. Here's a thread with some of the objects you'll need, http://www.thescripts.com/forum/thread641830.html

[Killer42]

No VB6 here, but it maybe the Tools, References menu. Maybe even Ctrl R. In any case, it's the References or Add References menu...

It's under Project | References.

[SammyB]

It's under Project | References.

How quick we forget!

[CaptainD]

hi i have written one progrm in vb but i want its output in excel but i am not able to coonect excel to vb so plz help me

Private Sub Command1_Click()
Dim oXLApp As Excel.Application

Dim strPath As String
strPath = "PathToWorksheet"
Set oXLApp = New Excel.Application
Set oxlBook = oXLApp.Workbooks.Open(strPath)
Set Worksheet = oXLApp.Worksheets(1)

oXLApp.Visible = True  'If you want to open the workbook

End Sub