By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,064 Members | 1,524 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,064 IT Pros & Developers. It's quick & easy.

Automation of Office

P: n/a
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
Nov 20 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
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

Nov 20 '05 #2

P: n/a
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

Nov 20 '05 #3

P: n/a

"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
Nov 20 '05 #4

P: n/a
Hi Marco,

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

Cor
Nov 20 '05 #5

P: n/a
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

Nov 20 '05 #6

P: n/a
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


Nov 20 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.