just some ideas. IF you can use the create object to expose the other applications object models then send them commands. and maybe an API spy to get the handels of the applications forms and controls then use the send message api to send commandes to the forms. These may or may not be...
I had a similar problem. If all of the spreadsheets are in a common folder that helps. and it generally helps to have named cells or ranges so that it is easier to find stuff. Basically you just make a macro that opens up each excel file in the folder find the data then and write it to your...
