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

Personally, I have never heard of Progress, but before you can even consider doing anything like that
1. You would need to find out if Progress supports Automation
2. Get access to its object library, add it to your registry, and set a reference to it in Excel

----- Fred Smith wrote: ----

My company uses a third party Progress database for our clients. One of th
neat features is that we can export data to Excel. This allows me to writ
macros so I can generate additional information on the clients. (I know hea
office should be doing this so I can spend more time selling, but you kno
how IT departments are.

The problem is I can export only one client at a time. I'd actually like t
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 comman
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 th
Progress program and feed it the same stuff I would type, then resume th
macro once it's received the data

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

As always, thanks for your help

Fre
Please reply to newsgroup, not e-mai

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

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