integrating excel into 3rd party software without an import function

[watsonla]

I have been set a task to try and use data that is in excel and automatically fill in a template that at the moment has to be manually input. there is no bulk import feature.

In excel i have rows of data, each row has approx 20 fields.
each row with 20 fields has to be manually input into another encrypted program. This is causing many copy problems, as we can have upto 100-150 rows of data to copy across manually.

The problem i have is I have top export from excel into the 3rd party software, we have to input 7-10 fields, then select ok and then fill in the remaining fields on page 2 of the 3rdf party software and select ok again. Then we have to repeat the process for line 2 in our excel sheet... and repeat until all excel rows are finished.

Does anyone know if this is a process i can automate, eg open excel, open third party software, copy fields from excel and paste in the correct fields in 3rd party software, select ok on 3rd party software to move on to page 2 and copy next set of fields from excel and paste to selected fields in page 2, "enter" to finalize the 3rd party software and then repeat the whole process for line 2 in excel and repeat until end of excel. this means opening and closing 3rd party software many times over until excel reaches the end of the list.

I would be grateful if anyone knows how to do this, or can point me in the right direction.

many thanks in advance.

len

 

[Smitty]

What's the 3rd party app?

I'd probably start with the app provider. Have you contacted them to see if they have an import or API function?

 

[watsonla]

sadly the 3rd part software application is not supported and the company has gone out of business

 

[Smitty]

You'd probably want to look into using Send Keys then. It's not too reliable, but in many cases it's the only viable way to talk to another app.