use namespace in VB.NET

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Maileen - 20 Oct 2004 20:01 GMT

Hi,

I would like to know how can we use a namespace in VB.NET ?
i tried :
Imports xlApp = Microsoft.Office.Interop.Excel
and
Dim test As New Microsoft.Office.Interop.Excel

but without success.
First i install PIA for Office XP and include the COM as usual.
Is there something else to do first ?

thanks a lot,
Maileen

Reply to this Message

Jay B. Harlow [MVP - Outlook] - 20 Oct 2004 20:12 GMT

Maileen,

> First i install PIA for Office XP and include the COM as usual.
> Is there something else to do first ?

What do you mean "include the COM as usual"?

You need to install the PIA first as you did. Then you use "Project - Add
Reference - COM" and select Microsoft Excel, VS.NET will see that there is a
PIA available and use the PIA.

After you add the reference you should be able to import the namespace. You
may want to use Object Browser, after you Add Reference, to ensure that you
are using the correct namespace, as I seem to remember that the namespaces
differ when you are using a PIA or not.

Hope this helps
Jay

> Hi,
>
[quoted text clipped - 10 lines]
> thanks a lot,
> Maileen

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...