Hello all,

I have been developing a fairly large data-mining/reporting system for several months now using VB6+SQL Server 2k+Excel XP. The application is now being overhauled and re-done using VB.net. Luckily since most of the development so far was on the backend, we haven't had any nasty surprises while porting the app and creating custom objects, but this one issue stumped me.
To report the results, the app. passed an array of ADODB recordsets to an Excel macro which then knew how to populate the sheets using the data.
This approach (rather than automate the populating the sheets from within the main app) is very important because I believe this lets us scale the app. to support many more reports in the future. Also, the display logic is localized in each report, thereby solving a lot of problems that cropped up. Here is the problem.
My application now has a dataset that has been passed back by a Local service.
How do I pass a dataset to my macro?
Does vba support .net ?
Can I program vba macros with the IDE?
Or do I write a mapping function that turns my datasets into adodb recordsets which can then be passed to the local macros to be displayed?
I still have a few weeks before I actually get to this point, so any advice / ideas would be most welcome!

TIA,
Prashanth