How to Export A Report From Excel with a cummulative balance

[MUIGAIPCCL]

I have a report which is done in Vfp7 and I want to export it to Excel. It is a cashbook statement. I have managed to export the debits and the credits but not the cummlative balance. An exapmle below.


Date Debit Credit Balance

01/01/2003 opening Balance 3000.00
02/01/2003 Banking 2000.00 5000.00
03/01/2003 Withdrawals 1000.00 4000.00

Anybody out there to help me be able to get the cummulative balance column(last column) programmatically.

 

[Mike Lewis]

You could achieve this via COM Automation, but it would need quite a bit of programming.

A better solution would be to invest in FRX2ANY from Neova
(

http://www.neova.ca).

This lets you convert an FRX to an Excel file in just three or four lines of code.

Crystal Reports can also export to Excel -- and is very much faster than FRX2ANY.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk