capturing Excel (Visual Basic)

Topic

New Reply

I just got Visual Studio.NET and am trying the following:

Dim objExcel As Excel.Application ‘ Object variable to capture Excel

Which fails with the message:

Type ‘Excel.Application’ is not defined.

What am I doing wrong?

Reply | Quote

Replies

Ronald,

I don’t have VB.net installed yet, so I’m not quite sure…

but, in VB6 you would have to check a reference to the Excel application (in vb6- tools, references- and select Microsift Excel from the list)

Reply | Quote

That sounds right but I can’t find the dll? file. What would it be called in Office 97?

Reply | Quote

Not sure about 97- but Excel 2000 is on my computer at c:program FilesMicrosoft OfficeOfficeExcel9.OLB

It’s in the dropdown list (from Tools, Refverences) as “Microsoft Excel 9.0 Object Library”

Though it’s possible .NET does things completely differently.

Reply | Quote

There are some notes about PIA’s at
http://msdn.microsoft.com/library/default….odc_oxppias.asp[/url]
but these are for Office XP

Reply | Quote

You’re close, Ronald. To add a reference to the appropriate library, choose Add Reference from the Project menu. Click on the COM tab, and scroll down to the Microsoft Excel 10.0 Object Library. After you’ve added it, you should stop seeing the Blue Squiggle of Terror when you type something like:

Dim oExcel as New Excel.Application()

I believe you have to have Excel 2002 installed on the machine running VS.NET, though. You can check KB Q328912 for some info on downloading the Primary Interop Assemblies, another acronym for the dyslexicon, to work with Office XP COM libraries. Good luck!

Reply | Quote