VBA to Pull Data from Accpac or Crystal Report

[DeWaal Le Grange]

Hi There excel experts

I would like if someone could help me and explain to me how i can run a VBA code that will pull data from a report i created in Crystal report which pulls data from Accpac.

What i do is i print this report and type in the data automaticaly in excel. i need a VBA code that will do this form me, it will minimize the chances of human error.

Please could anyone help me with this.

Thanks
DeWaal

 

[Norie]

DeWaal

Is there no way you can allow the user to enter data into either of these applications?

Do you really need to import it to Excel?

 

[DeWaal Le Grange]

Hi Norie

No, the Crystal report works like this: it gives me the sales by day of all agents in our company... the it sums up those figures.

eg.

1/07/09 33500
2/07/09 55264
3/07/09 56553

Sum (145317)

i only need the vba to copy the sumed up values to excel.