Automation of Office

[Marco Singer]

Hi all,

is there any way to create a VB.NET application that automates MS Word and
Excel and works with all Office versions from 97 and newer? I currently have
Office XP installed.
Ok, I could declare all office type variables as "object" and create an
application instance with CreateObject().
But I want to use Intellisense and use the object browser for class member
reference.

Any hints?

Thanks

Marco

[Anand[MVP]]

reference the Microsoft Excel or Word object library. And program against that. The only problem is that each version of Office has a different library. One option is to have sperate library projects for each version of Office. That way each project can reference the correct version of Office and you main app chooses which DLL to use based on the office version available.

Rgds,
Anand
VB.NET MVP
http://www.dotnetindia.com

"Marco Singer" wrote:

Hi all,

is there any way to create a VB.NET application that automates MS Word and
Excel and works with all Office versions from 97 and newer? I currently have
Office XP installed.
Ok, I could declare all office type variables as "object" and create an
application instance with CreateObject().
But I want to use Intellisense and use the object browser for class member
reference.

Any hints?

Thanks

Marco

[Cor Ligthert]

Hi Marco,

Have a look at these links,

I hope they help?

Cor

Office
http://support.microsoft.com/default...b;EN-US;311452

http://msdn.microsoft.com/office/

Pia Download
http://www.microsoft.com/downloads/d...displaylang=en

Excel dataset fill and updat
http://support.microsoft.com/default...b;EN-US;316934

is there any way to create a VB.NET application that automates MS Word and
Excel and works with all Office versions from 97 and newer? I currently have Office XP installed.
Ok, I could declare all office type variables as "object" and create an
application instance with CreateObject().
But I want to use Intellisense and use the object browser for class member
reference.

Any hints?

Thanks

Marco

[Marco Singer]

"Cor Ligthert" <no**********@planet.nl> schrieb im Newsbeitrag
news:Ox**************@TK2MSFTNGP10.phx.gbl...

Office
http://support.microsoft.com/default...b;EN-US;311452

On a linked page appears this:

"Reference the type library of the earliest version of the Office
application you intend to Automate."

Ok, but where can I obtain type libraries of older Office versions?

Marco

[Cor Ligthert]

Hi Marco,

I do not know where you can get the oldest versions, maybe somebody else
knows that.

Cor

[Sriram Krishnan]

There was a MSDN article about the office PIAs which spoke about where to
obtain the older versions of the PIAs and how to set them up. I can't find
them right now - maybe someone else can help out?

--
Sriram Krishnan
Microsoft Student Ambassador
http://www.dotnetjunkies.com/weblog/sriram
"Cor Ligthert" <no**********@planet.nl> wrote in message
news:ec**************@TK2MSFTNGP11.phx.gbl...

Hi Marco,

I do not know where you can get the oldest versions, maybe somebody else
knows that.

Cor

[Marco Singer]

It seems there is a PIA package for Office 2000 and Office XP, but not for
older versions. I want to write an automation client for Office 97...

Marco

"Sriram Krishnan" <ks*****@NOSPAMgmx.net> schrieb im Newsbeitrag
news:%2***************@tk2msftngp13.phx.gbl...

There was a MSDN article about the office PIAs which spoke about where to
obtain the older versions of the PIAs and how to set them up. I can't find
them right now - maybe someone else can help out?

--
Sriram Krishnan
Microsoft Student Ambassador
http://www.dotnetjunkies.com/weblog/sriram
"Cor Ligthert" <no**********@planet.nl> wrote in message
news:ec**************@TK2MSFTNGP11.phx.gbl...

Hi Marco,

I do not know where you can get the oldest versions, maybe somebody else
knows that.

Cor