Excel reference doesn't work

[Jamie]

HI, I'm using the Visual Studio trial and trying to write a simple program
that opens an Excel file. I can add the reference to the excel interop
assambly OK, but then it doesn't expose the functions to my app. for
instance when I type

Dim EXL As New Excel.Application

it gives me

Type 'Excel.Application' is not defined.


I've tried downloading the Office XP PIA files and referenceing them
dirsctly, but still no good. I've also tried referenceing the OPutlook
library and I don't get that functionality either...??? I tried the same
thing at work and the stuff works just fine... what could be wrong with my
setup at home???



Thanks

Jamie

 

[Herfried K. Wagner [MVP]]

HI, I'm using the Visual Studio trial and trying to write a simple program
that opens an Excel file. I can add the reference to the excel interop
assambly OK, but then it doesn't expose the functions to my app. for
instance when I type

Dim EXL As New Excel.Application

it gives me

Type 'Excel.Application' is not defined.

HOWTO: Automate Microsoft Excel from Visual Basic .NET
<URL:http://support.microsoft.com/?scid=kb;EN-US;301982>

 

[Sriram Krishnan]

Have you imported the correct namespaces?



--
Sriram Krishnan
Microsoft Student Ambassador
http://www.dotnetjunkies.com/weblog/sriram