By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,064 Members | 1,524 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,064 IT Pros & Developers. It's quick & easy.

Excel reference doesn't work

P: n/a
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
Nov 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
* "Jamie" <ja***@geeksgonebad.com> scripsit:
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>

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>
<URL:http://dotnet.mvps.org/dotnet/faqs/>
Nov 20 '05 #2

P: n/a
Have you imported the correct namespaces?

--
Sriram Krishnan
Microsoft Student Ambassador
http://www.dotnetjunkies.com/weblog/sriram
"Herfried K. Wagner [MVP]" <hi***************@gmx.at> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...
* "Jamie" <ja***@geeksgonebad.com> scripsit:
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>

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>
<URL:http://dotnet.mvps.org/dotnet/faqs/>

Nov 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.