Hi,
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