Re: Which tools are needed to do Office automation



Hi Andre,

I used to do some MS office automation from my applications. Mainly
mail-merges and small Excel tables.

Can I still automate Office2000 docs or will I need 2003/2007?
How to do that with VS pro? Which tools do I probably need in addition to VS
pro?
I tried to find a trial or a demo for the "VSTools for Office (VSTO)", but
there is none.
Is that what I need to do a comfortable automation?

You can automate Office 2000 using Visual Studio, but there won't be a
pre-installed set of PIAs available. When you set a reference to an Office 2000
app's type library (in the COM, not the .NET tab!) Visual Studio will run
TlbImp.exe and generate a set of IAs in your project's folder. You then need to
distribute these with your project.

(Office 2002 and 2003 have PIAs, provided by Microsoft, that are installed in
the GAC, making them available to all. Yours will be specific to your project.)

If you're automating Office, you don't want to use VSTO, just Visual Studio.
And anyway, VSTO only works with version 2003 and above.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

.



Relevant Pages

  • Re: VC 7.1 command line output
    ... Automate your software builds with Visual Build Pro ... > I'm trying to create an automated build, so I've created a batch file with ...
    (microsoft.public.vc.ide_general)
  • Re: Entourage / Office 2007 / VBA
    ... However, Rb doesn't rely on existing macros to automate Office, so there would be no need to have VBA code, or have access to that code, in a document. ...
    (microsoft.public.mac.office)
  • Re: VS2005 always builds as 2.0 Framework?
    ... of the Framework, ... if i open this project in Visual Studio 2005, ... Automate your software builds with Visual Build Pro ...
    (microsoft.public.vstudio.general)
  • Re: 2005 too smart for its own good?
    ... It is recommended to declare each object as a new variable when we automate ... a Microsoft Office application from Microsoft Visual Basic .NET or ... Otherwise, it may cause some exceptional errors, e.g ... Office application does not quit after automation from Visual Studio .NET ...
    (microsoft.public.dotnet.languages.vb)
  • Help with Visual Studio Automation
    ... I'm in need of some guidance. ... to automate the addition of projects to a visual studio solution. ... These test projects live very close ...
    (microsoft.public.vsnet.general)