macro to get data from one application into excel
 

Hiya! Can someone tell me how to wrire a macro to get data from an
application(primavera) and paste it into a worksheet to be formated, the
formatting that i will do i can record no problem.
But i just need it to get the data and paste in excel...
Thanks

macro to get data from one application into excel
 

For XL to talk to another application, that application needs to have some
kind of an interface (known as an API or Application Process Interface). I am
not familiar with Primavera so I have no idea if it has an API or not.
--
HTH...

Jim Thomlinson


"whatzzup" wrote:

Hiya! Can someone tell me how to wrire a macro to get data from an
application(primavera) and paste it into a worksheet to be formated, the
formatting that i will do i can record no problem.
But i just need it to get the data and paste in excel...
Thanks