Automation of Office

  • Thread starter Thread starter Marco Singer
  • Start date Start date
M

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
 
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
 
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?
 
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
 
Back
Top