ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Automating Excel w VB.Net 2003 (https://www.excelbanter.com/excel-discussion-misc-queries/46826-automating-excel-w-vbulletin-net-2003-a.html)

[email protected]

Automating Excel w VB.Net 2003
 
I'm attempting to teach myself automation of Excel 2003 using Visual
Studio.Net 2003.

I did Project---Add Reference and loaded both Excel 11.0 Object
Library and Excel 5.0 Library. When I attempt to dim objExcel as New
Excel.Application, I get error saying type Excel.Application is not
defined.

But Excel IS installed.... I use it all the time. When I go to
Help---About---System Summary---Office 2003
Applications---Microsoft Excel 2003---Summary, it says I have Version
11 Build 6355.

Can somebody point me in the right direction what I'm doing wrong?



All times are GMT +1. The time now is 07:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com