How to dynamically generate the fields in excel report using VB 6.0

[Ramchandar]

I would like to create a dynamic report in excel using VB6.0.

I am having many recordset and i would be using these separate recordset to prepare report in excel. I have a separate format also for this. Say for example each cell value in excel would be from a separate recordset. The data for this recordset would be from SQL.

Can u please suggest me some freeware or some source code to achieve this task.

[debasisdas]

What did Google say ?

Have you tried for that option ?