Exporting to Excel

[bobsmallwood]

What code can I put on a pushbutton that will export a database table in my RIV: directory to an excel format file in another directory?

Is there additional code that would then launch Excel (if necessary) and then open the excel file just created?

 

[Langley]

Try this:

exportSpreadsheet (":work:myData.db", "riv:myData.xls", True)

Then use execute() to launch Excel with a command line argument containing your spreadsheet path and name; or, you can use a DDE link if you know Excel's DDE behavior.



Mac

"There are only 10 kinds of people in this world... those who understand binary and those who don't"

langley_mckelvy@cd4.co.harris.tx.us

 

[bobsmallwood]

Thanks much. Do I need to define any variables first?

 

[Langley]

No, not unless you want to substitute variables for the table name or spreadsheet name.

Mac

"There are only 10 kinds of people in this world... those who understand binary and those who don't"

langley_mckelvy@cd4.co.harris.tx.us

 

[bobsmallwood]

I'll give it a shot!