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

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

Since the link addresses automation and he said he did what is at the link
and he says he can see the objects in the object browser, then I would guess
it supports automation.

To the OP,
if you post the name of the application, then maybe someone can advise you.
If not, then get the automation help file:


http://support.microsoft.com/?id=253338
INFO: Office Developer Samples and Tools Available for Download

http://support.microsoft.com/?id=260410
OFF2000: Microsoft Office 2000 Automation Help File Available

and learn about automation.

--
Regards,
Tom Ogilvy



"RB Smissaert" wrote:

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

You might be right, but why should we be guessing?

RBS

"Tom Ogilvy" wrote in message
...
Since the link addresses automation and he said he did what is at the link
and he says he can see the objects in the object browser, then I would
guess
it supports automation.

To the OP,
if you post the name of the application, then maybe someone can advise
you.
If not, then get the automation help file:


http://support.microsoft.com/?id=253338
INFO: Office Developer Samples and Tools Available for Download

http://support.microsoft.com/?id=260410
OFF2000: Microsoft Office 2000 Automation Help File Available

and learn about automation.

--
Regards,
Tom Ogilvy



"RB Smissaert" wrote:

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

I am recommending some sources of information that use specific searchable
language that are probably appropriate for the problem/situation described.

If this turns out not to be the case, I don't see much use for the Windows
API to provide a programmatic interface to the application and the reerences
provided are nonetheless useful.

As to custom API's to allow something similar to automation, beyond DDE, I
can't think of any "big names".

To you, I pointed out the circumstantial evidence provided that seems to
indicate automation is supported since you appeared to ignore that in your
response.

--
Regards,
Tom Ogilvy





"RB Smissaert" wrote:

You might be right, but why should we be guessing?

RBS

"Tom Ogilvy" wrote in message
...
Since the link addresses automation and he said he did what is at the link
and he says he can see the objects in the object browser, then I would
guess
it supports automation.

To the OP,
if you post the name of the application, then maybe someone can advise
you.
If not, then get the automation help file:


http://support.microsoft.com/?id=253338
INFO: Office Developer Samples and Tools Available for Download

http://support.microsoft.com/?id=260410
OFF2000: Microsoft Office 2000 Automation Help File Available

and learn about automation.

--
Regards,
Tom Ogilvy



"RB Smissaert" wrote:

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

The only point I was making is that the question could be put better.

RBS

"Tom Ogilvy" wrote in message
...
I am recommending some sources of information that use specific searchable
language that are probably appropriate for the problem/situation
described.

If this turns out not to be the case, I don't see much use for the Windows
API to provide a programmatic interface to the application and the
reerences
provided are nonetheless useful.

As to custom API's to allow something similar to automation, beyond DDE, I
can't think of any "big names".

To you, I pointed out the circumstantial evidence provided that seems to
indicate automation is supported since you appeared to ignore that in your
response.

--
Regards,
Tom Ogilvy





"RB Smissaert" wrote:

You might be right, but why should we be guessing?

RBS

"Tom Ogilvy" wrote in message
...
Since the link addresses automation and he said he did what is at the
link
and he says he can see the objects in the object browser, then I would
guess
it supports automation.

To the OP,
if you post the name of the application, then maybe someone can advise
you.
If not, then get the automation help file:


http://support.microsoft.com/?id=253338
INFO: Office Developer Samples and Tools Available for Download

http://support.microsoft.com/?id=260410
OFF2000: Microsoft Office 2000 Automation Help File Available

and learn about automation.

--
Regards,
Tom Ogilvy



"RB Smissaert" wrote:

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