borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincaniborder

AndreaVB | Forum | News | Downloads | Register | Help | Member List | Statistics | Search | PM | Profile

Print This Topic
Previous Topic (sos)Next Topic (Vb.Net tutorial / getting started course notes) New Topic New Poll Post Reply
AndreaVB Forum : VB.Net : Accessing Excel TextBox from VB.net
Poster Message
david_gunawan68
Level: Guest


icon 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"

30-10-2003 at 10:45 PM
| Quote Reply
AndreaVB Forum : VB.Net : Accessing Excel TextBox from VB.net
Previous Topic (sos)Next Topic (Vb.Net tutorial / getting started course notes) New Topic New Poll Post Reply
Surf To:


Not Logged In? Username: Password: Lost your password?
Partners: Download Actual Software | Free Software Download
borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincaniborder