I think you can. I do this with a couple of my applications at work.
Using code like this:

Shell "y:\Fedfar\Exe\FedFar.exe", vbNormalFocus ' opens application
Application.Wait Now + TimeValue("00:00:08") ' waits for application
Application.SendKeys "{enter}", True ' sends key strokes to
application.

Look in the VBA help for more info.

Good Luck





"Suzette" wrote in message ...
The only way for Excel to be able to do it is if the Progress program works
with VBA and has the ability to be linked to from an outside program.

More than likely, you are out of luck.

Sue
"Fred Smith" wrote in message
...
My company uses a third party Progress database for our clients. One of
the
neat features is that we can export data to Excel. This allows me to write
macros so I can generate additional information on the clients. (I know
head
office should be doing this so I can spend more time selling, but you know
how IT departments are.)

The problem is I can export only one client at a time. I'd actually like
to
export my entire client list, so I can work on the entire book. Right now,
we go to the Progress program, call up the client, and use the menu
command
ToolsExport Excel Spreadsheet. Progress opens up a new instance of Excel,
exports the data, and I go from there.

Is it possible to automate this with an Excel macro? Can Excel call up the
Progress program and feed it the same stuff I would type, then resume the
macro once it's received the data?

I'm on my own on this. I certainly won't get any help from the IT
department
to, for example, modify the Progress program. It all has to be done in
Excel.

As always, thanks for your help.

Fred
Please reply to newsgroup, not e-mail