[Closed] Business objects and Excel

I found, and since lost, a reference to the fact that you can create/populate excel spreadsheets directly from crystal, starting from excel. The current approach is to export as csv from crystal then spend a while manipulating the data in excel to show what i need it to show.

I don't know how it works or whether it would work for what i want but does anyone know where i might get some more information, preferably on line and free, on how run crystal reports from within excel, i guess using macros/functions/vba to populate cells on a predesigned worksheet.