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