VB .NET Excel question

LUbud

This might sound easy to answer but I am getting a Type is Not declared Error for:
Dim xl As Excel.Application
Dim myWorkbook As Excel.Workbook

Am I suppose to import a namespace? Am I missing a something?

Thanks.

Chris__B

Hi,

If you haven't already done so, you may want to try adding a reference to Microsoft Excel 9.0 Object Library (Project > Add Reference > COM)
or you can declare each as objects (e.g. Dim xl as Object) without adding the reference.

Cheers,
Chris

: This might sound easy to answer but I am getting a Type is Not declared Error for:
: Dim xl As Excel.Application
: Dim myWorkbook As Excel.Workbook
:
: Am I suppose to import a namespace? Am I missing a something?
:
: Thanks.
:

raymcd

: This might sound easy to answer but I am getting a Type is Not declared Error for:
: Dim xl As Excel.Application
: Dim myWorkbook As Excel.Workbook
:
: Am I suppose to import a namespace? Am I missing a something?
:
: Thanks.
:
You have to add a reference to Excel. You'll see it on the com tab. You'll get a namespace from com interop.

-ray

LUbud

: : This might sound easy to answer but I am getting a Type is Not declared Error for:
: : Dim xl As Excel.Application
: : Dim myWorkbook As Excel.Workbook
: :
: : Am I suppose to import a namespace? Am I missing a something?
: :
: : Thanks.
: :
: You have to add a reference to Excel. You'll see it on the com tab. You'll get a namespace from com interop.
:
: -ray
:


Thanks Chris and Ray :-)

Dan

CLJohn

I

filipk

This post has been deleted.

cikaPero

Hi,

you are probably missing reference to Excel Automation library.
But I recommend you to stop working with Excel Interop, it has a lot of problems. One major problem is if there are different versions of Excel installed in development and production environment - then everything falls apart.

For [link=http://www.gemboxsoftware.com/GBSpreadsheet.htm]Excel C#[/link] and [link=http://www.gemboxsoftware.com/GBSpreadsheet.htm]Excel VB.NET[/link] applications I use GemBox.Spreadsheet [link=http://www.gemboxsoftware.com/GBSpreadsheet.htm].NET Excel[/link] component.

Much more easier to use and much more faster that Excel Interop.

Jason663

I have had good success with this library:

[link=https://www.kellermansoftware.com/p-52-excel-reports.aspx] https://www.kellermansoftware.com/p-52-excel-reports.aspx[/link]

Jason663

I have had good success with this library:

[link=https://www.kellermansoftware.com/p-52-excel-reports.aspx]https://www.kellermansoftware.com/p-52-excel-reports.aspx[/link]