jdana
asked on
Looking for .NET Excel Class
In the following article, Senthil S. uses the following code:
Article: http://www.codeproject.com/KB/vb/Senthil_S__Software_Eng_.aspx
Code:
Article: http://www.codeproject.com/KB/vb/Senthil_S__Software_Eng_.aspx
Code:
With Excel
.SheetsInNewWorkbook = 1
.Workbooks.Add()
.Worksheets(1).Select()
...
Unfortunately, he doesn't include a Dim statement for the Excel object. My best guess is this: Dim Excel As Microsoft.Office.Interop.Excel.Workbook
Am I wrong? Am I right?ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
He has this line earlier in the article
Dim excel As New Microsoft.Office.Interop.Excel.ApplicationClass
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Alfred nailed it. (I'm running VS 2010 and "Embed Interop Types" set to TRUE.)
Thanks all.
Thanks all.
Microsoft.Office.Interop.E