david_gunawan68 Level: Guest

|
Accessing Excel TextBox from VB.net
I have a VB.net program that create an Excel file and inserting data into the cells.
Now I need to insert data (text) into a TextBox in the Excel worksheet.
Anybody know how to do this in VB.net ?
So far this is what I have, but I have a run time error in the last line.
Dim Xls_new As Excel.Worksheet
(the I read an existing Excel file with a TextBox in it)
Xls_new.OLEObjects(1).Object.Value = "Test"
|