I generate a data report and control information in 2 separate files. The control information contains information such as number of reports, where the report starts, number of columns etc. The excel VBA macros use that control information and format the data in the excel spreadsheet. Here is what I want to do. As report is generated from the VB, VB program has access to the control information. I want to make an object model from that control information and expose those objects to VBA macros, so that anybody can have easy access to data and do whatever they want with that data.
How do I expose the objects from VB to excel VBA ? Or any other better suggestions .
I don't have many points, so giving only 10.