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

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
>
>
>

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
>
>

"Cor Ligthert" <(E-Mail Removed)> schrieb im Newsbeitrag
news:(E-Mail Removed)...
>
> 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

Hi Marco,

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

Cor

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi Marco,
>
> I do not know where you can get the oldest versions, maybe somebody else
> knows that.
>
> Cor
>
>

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" <(E-Mail Removed)> schrieb im Newsbeitrag
news:%(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Hi Marco,
> >
> > I do not know where you can get the oldest versions, maybe somebody else
> > knows that.
> >
> > Cor
> >
> >
>
>