I have a crystal report which I would like to be able to export to a pre-saved Excel template, i.e. the first 10 columns contain the data and the next 10 columns contain formulas based upon the data imported into the spreadsheet.  Is this possible?  I know it's easy enough to export to Excel, but it always creates a new file.  I'm guessing it's something I would probably need to tackle using VBA.

 

The version of Crystal is v10 and the data is coming from SQL Server 2000.

 

Thanks