Adding Excel Object Library conflicts between Excel.TextBox & Forms.TextBox in Office Development

Question

I have implemented several basic Excel functions in my vb.net application (opening an xls workbook & accessing worksheet). However, it appears that when I add the Reference "Microsoft Excel 14.0 Object Library" the application is getting confused with the standard System.Windows.Forms objects and has the following error: InvalidCastException occured: Unable to cast object of type 'System.Windows.Forms.TextBox' to type 'Microsoft.Office.Interop.Excel.TextBox'. The Invalid Cast error is happening when calling a subroutine & passing the application form controls (check boxes, GridView, TextBox, etc) from my main "Form1" class into a UtilityFunction module. UtilityFunction has a reusable Windows Registry sub routine which retrieves/saves values at application startup/closing. This worked in the past, but now is crashing at the subroutine call in the Form1 class. The exception occurs during application runtime, not during the compile/build.

Also, I deleted the text controls from the form and created them manually, but I'm still getting the same exception error.

Fully qualify the namespace to your object your wanting.

OneFineDay
– OneFineDay

2014-02-05 23:05:42 +00:00
Commented Feb 5, 2014 at 23:05 — OneFineDay
– OneFineDay, Commented Feb 5, 2014 at 23:05

OneFineDay · Accepted Answer · 2014-02-05 23:07:51Z

0

When you have a Namespace conflict you need to fully qualify the object you want.

Dim excelTb As New Microsoft.Office.Interop.Excel.TextBox
Dim formTb As New System.Windows.Forms.TextBox

answered Feb 5, 2014 at 23:07

OneFineDay

9,0344 gold badges28 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user3280396 · Accepted Answer · 2014-02-06 16:08:50Z

0

I solved this problem by using the following code:

Imports X = Microsoft.Office.Interop.Excel

Dim xlApp As X.Application = New X.Application

answered Feb 6, 2014 at 16:08

user3280396

172 bronze badges

Collectives™ on Stack Overflow

Adding Excel Object Library conflicts between Excel.TextBox & Forms.TextBox in Office Development

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related