Hello,

I have a complicated report in which I am using Excel as a method of displaying the data. Admitedly, I haven't done any of the coding yet but this is the plan...

1.) Use the VBA code in Excel to call 4 Stored Procedures. Data from these Stored Procedures is then used to populate the spreadsheet (around 400 cells need populating in various places)
2.) The VBA code will then Save this spreadsheet.

OK so far, now, here is the bit I am very unsure about. We use Crystal Reports version 10 and the Crystal Management Console version 9. Will it be possible to programmatically deploy the saved spreadsheet to the Management Console using VBA code?

Any code snippets will be much appreciated.

Thank you in advance.