I have a program I wrote a few years ago that interfaces largely with MS Excel. At the time my company used Office 2007. We have since upgraded to 2010 with no problems. However, I had to make some adjustments, and now I can not compile. The error is
Error 3 Type 'Microsoft.Office.InteropExcel.Application' is not defined. P:\ASG\VB Backup\Current Programs\ALL SUS TRAINING\WindowsApplication2\Form1.vb 5 23 WindowsApplication2
My code below is the header I've used since first release.
Imports Microsoft.Office.Interop Imports Microsoft.Office.Interop.Excel Public Class frmImportDoc Dim trFile As New Microsoft.Office.InteropExcel.Application Dim trSheet As New Microsoft.Office.InteropExcel.Worksheet
So far, I have tried deleting and re-importing all of the office references (both Office and Excel Object Libraries).
If anyone has any ideas on this, I would greatly appreciate the help!