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