What kind of other program are you thinking of?
It probably is possible with the help of the Windows API.
Sometimes those other programs have their own API that
can accessed by setting a reference to it in the VBE.
If that is the case it can make things much simpler.

RBS

wrote in message
oups.com...
Hi

How do I access another program from Excel? What I'd like to do is
click on line in Excel with information about a journal and have Excel
automatically go to another program, paste one of the fields from the
line and send a search request. The other program is a Windows XP
program.

The best information that I've found so far is

http://peltiertech.com/Excel/XL_PPT.html

Following these instructions, I can see in Excel a list of functions
that the other program has, however, I don't know of any documentation,
or whether these functions tend to be parallel in other programs.

Another option is for me to try and write a Visual Basic program that
will access both Excel (or another data source--could be a text file or
comma delimited file exported from Excel) and the other program.

Could anyone recommend a source of information, or example code, or any
other recommendations?

I'd appreciate an email copy of any response.

Have a nice day
John Paul Fullerton