How do I make my automation code hook on to an open application?

[Kristian]

Hello,
I've written some code that performs some automation in
Excel. My code creates a new workbook and enters some
stuff from my Word document.
Problem:
I set an object variable = NEW Excel.Application
Hence, although Excel is running the code opens
a new copy of the Excel application into memory.

Anyone got a nice solution to this?

Thanks in advance,
Kristian

 

[Cindy M -WordMVP-]

Hi Kristian,

Type GetObject into a module, then press F1 to open the
Help to that topic.

I've written some code that performs some automation in
Excel. My code creates a new workbook and enters some
stuff from my Word document.
Problem:
I set an object variable = NEW Excel.Application
Hence, although Excel is running the code opens
a new copy of the Excel application into memory.

Anyone got a nice solution to this?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.mvps.org/word

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