After using Xojo for a month

[Eugene_Dakin]

@259952:@Tony Lam

I heard of your website in another post “I wish I can Program… Excel”, but I can’t reach that link, I would like to export a fancy excel report for my clients but I don’t know how by the moment

My website is scispec.ca and click on the link called ‘Books’ and you can review a download with an example, and books can be purchased at RbLibrary.com

@259952:@Tony Lam

Just a quick question: I can’t change the color by excel.Range(“A1:B10”).Font.color=RGB(255,0,0), any suggestion?

[code] Dim excel as new ExcelApplication
Excel.Workbooks.Add
excel.Visible = true

excel.Range(“A1:B10”).Value = “data”
excel.Range(“A1:B10”).Font.Color_ = 255 //Red ColorNumber [/code]
Here is code to change the font colour. The word Color_ must have an underscore after the word, and the colour is an Excel colour number. The Excel colour number 255 = RGB(255,0,0). An Excel colour converter example is supplied in the book in Example3-8.

Happy to help.

[Emile_Schwarz]

@259747:@Tony Lam

can’t save my project module by module, for instance, if I have made changes to several modules but made mistake in the last module, I can’t just reload the last module to avoid changes

Not sure about what you’re talking. Here’s an answer if I understand your sentence correctly:

In the navigator (the left “column”, the place where you see your windows, Methods, Class, Images, etc.):
Right-Click in an entry (say Window1) and export or save it.