how to export data to excel format from Visual basic

bimalkumar

hi 2 all,
i m using some txt boxes and few combo box in my form. how do i export the txt box and combobox data to excel sheet directly without using any database.just get the data from txt box and combo box and export it to excel.

while answering pls remember i m not regular VB coder. I just do it for some small application.
pls help me.

Sep 19 '06 #1

DPK

Dim appxl
Dim Book As Excel.Workbooks
Dim Wsheet As Excel.Worksheet
'Dim RngWSheet As Excel.Range
FileName = "c:\temp\new.xls"
Set appxl = CreateObject("Excel.Application")
Set Book = appxl.Workbooks
Set Wsheet = Book.Add.Worksheets(1)
'Set rngWSheet = Wsheet.Cells
appxl.Visible = True

Wsheet.Cells(1, 1) = combo.Text/text1.text

Wsheet.SaveAs (FileName)
Book.Close

Sep 20 '06 #2

bimalkumar

Thanks for ur rply.

Dim appxl
Dim Book As Excel.Workbooks
Dim Wsheet As Excel.Worksheet
'Dim RngWSheet As Excel.Range
FileName = "c:\temp\new.xls"
Set appxl = CreateObject("Excel.Application")
Set Book = appxl.Workbooks
Set Wsheet = Book.Add.Worksheets(1)
'Set rngWSheet = Wsheet.Cells
appxl.Visible = True

Wsheet.Cells(1, 1) = combo.Text/text1.text

Wsheet.SaveAs (FileName)
Book.Close

Sep 20 '06 #3

bimalkumar

Thanks for ur rply.

hi,
when i use your code it gives me error "user-defined type not defined". Is there any component to be used for this code.

pls help me

Sep 20 '06 #4

DPK

hi,
when i use your code it gives me error "user-defined type not defined". Is there any component to be used for this code.

pls help me

Hi Vimal !

U just have to give it reference of " Microsoft Excel Object Library "
Just check this check Box From Menu -[ Project > reference ].

Sep 22 '06 #5

dedydut

Hi Vimal !

U just have to give it reference of " Microsoft Excel Object Library "
Just check this check Box From Menu -[ Project > reference ].

Hi DPK, what if i want to add more data in excel... for example,
i have export data from "Database A" in excel file "test.xls"
now i want to export data from "Database B" in the same excel file, without replacing old data. and the result in excel file is "Database A" and "Database B" in one file... how to do that... thanks for your help...

Nov 16 '07 #6