Exporting Info into a Spreadsheet

[woodyinoz]

Hi all,

Ok, I really hope that someone knows how to do this because it'd make my life so much easier!!

I have a spreadsheet which runs a formula on certain columns values, lets say columns A, B and C with the formula being in column D.

I want to export/copy some information held in Paradox into the spreadsheets columns A, B and C and then for the formula in column D to run giving me the correct answer.
I want the transfer between the 2 packages to be as automatic as possible.

If anyone thinks they can help then please let me know.

Thanks,

Woody

 

[JoeNg]

You could use OLEAuto to interact with Excel. Or you could use the Pdox library created by Yaroslav Kvitchenko and Vladimir Menkin.

Download the Pdox-Excel library from

http://members.fortunecity.com/menkin/