Learnt that might need visual word to generate report in word document. Anyone try that before?

What about using Excel to generate report? Learnt that can actually formulate the cell.

I have tried using VB to do report generation. Also learnt from friends that can use VB to do report generation in MS Words. But I got no idea how to do that in VC++.

Need advice and sample code.