Click to See Complete Forum and Search --> : Open an Excel Document


nickj
July 18th, 2005, 01:44 AM
Hello people

Could someone please let me know how to open a Excel Document i have created so i can populate cells with some data i collect with a vb.net program

The data is put in to a textbox, then i click a button and the data will be put in to the cells.

Thanks Guys & Girls

scorpion1983
July 18th, 2005, 06:04 AM
HI
Have A Nice Day

Use This Code To Open Excel And add data to spread sheet coloumn

Dim objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
objExcel.Workbooks.Add()
objExcel.Cells(1, 1).Value = TextBox.Text

Where TextBox.text Picks Ur Data From TextBox

This Is all
Wait for ur Acknowledgement

Scorpion