Excel reference doesn't work

  • Thread starter Thread starter Jamie
  • Start date Start date
J

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
 
* "Jamie said:
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.
Click to expand...

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