Macros between 2 MS (or other) Applications

[Moe]

My problem might sound simple enough, but I can't figure out how to d
it.

Is it possible to have a macro in Excel that goes to anothe
application (possible MS Word or a different program), copy informatio
that is currently on screen and paste it in the next empty cell i
column A?

Also, is anyone familiar with a program called Vista? I really need t
construct a macro that interacts between Vista and Excel (pulls info of
the vista screen and puts it into excel)

 

[Jon Peltier]

Moe -

There are a few places you can look for information on automating one
Office app from another:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/wohowcommunication.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/office97/html/usingautomation.asp
http://msdn.microsoft.com/library/d...ariabletoautomateanotherofficeapplication.asp

I Googled Vista Software, and saw links to several different software
products. You have to find out if your Vista program has any kind of
automation links. Many third party packages have licensed VBA, and
therefore are able to expose their objects and data to Office VBA, in
the manner described in the articles above.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______