You probably don't have a reference to the COM Excel wrapper in your
References for the project.
This works for me, but it uses COM, and I don't know if .Net has direct
support for Excel yet:
1. Open Solution Explorer.
2. In the Project, right-click on References and choose Add Reference.
3. Select the COM tab.
4. Scroll down until you see Microsoft Excel <whatever> (Hint: type the
letter "M" to quickly scroll near to where you need to be in the list).
5. Highlight the Microsoft Excel entry (I had two, one for Excel 5 and one
for Excel 8) and click Select.
6. Click OK to close the dialog.
Open up a module and type the following
dim justatest as
As soon as you type the word "as", Intellisense should pop up and allow you
to type the letters Ex and the selection list should scroll to
Excel.Application. I just did this little exercise on a sample project that
had nothing to do with Excel and it works fine.
<Br***@nunyabuisness.com> wrote in message
news:jb*******************@newssvr25.news.prodigy. com...
Having used every combonation of excel 9/10/11 and office 10/11 possible
as references i still can not create an excel object! Any ideas?
Just using this simple bit below i get "Excel.appication not defined"
dim xlApp as Excel.Application, xlWs as Excel.WorkSheet
set xlApp = new Excel.Application