Automating the export and paste of information to excel.

[kryer12]

I have a a non microsoft application that pops up a report of times and names. Currently I have to go into the application. Do an export of data to a clipboard and then go to excel and do a paste of this data. I want to know how I might go about automating this process with the use of VBA. I have tried to do a macro recording but it wont work outside of OFFICE applications. Any help.

 

[shades]

I believe you have to use the ADO (ActiveX Data Objects) object model to access non-MS programs. To use be sure that you add the ADO Objects Library (in VBE, Tools > References.

 

[shades]

Check out this site to get started:

Connection Strings