Question about FWH and Excel

[driessen]

Hello,

Can someone tell me how I can change a backgroundcolor of a field in an Excel file from my FWH-application?

Thank you.

[ADutheil]

Try this
oSheet:Range( oSheet:Cells( 1, 1 ), oSheet:Cells( 1, 7 ) ):Interior:ColorIndex := Violeta

[driessen]

Thanks for your suggestion.

Where do I find the information how to build such FWH-code to control Excel?

Can I use RGB-codes?

[ADutheil]

Anytime I need something new I search Excel VBA examples and adapt them to FWH. As for RGB colors I don't know. Check below.

https://www.automateexcel.com/excel-for ... lor-index/

[driessen]

And how do you adapt vrom VBA to FWH?

[ADutheil]

I don't have a recipe but there are a lot of similarities: VAB Cells(x, y).Interior.ColorIndex <-> FWH Cells(x, y):Interior:ColorIndex.

[driessen]

And please, can you tell me how to add a sheet in an Excel-document?
And can you tell me how to change the name of the sheet?
Thanks.

[ADutheil]

Code: Select all

oExcel := win_oleCreateObject( "Excel.Application" )
oWorkb := oExcel:WorkBooks:Add()
oSheet := oWorkb:Sheets( number of the sheet you want to work with 1 2 3... )
oSheet:Name := "the name you want for your sheet"
 

PM me your mail I'll send you a code you can use to learn more about VBA methods and properties.

[hua]

http://wiki.fivetechsoft.com/doku.php?i ... el&s=excel could also be useful reference

[driessen]

Thank you all very much.
I found a answer to all my question, thanks to your help.