ThisWorkbook.Colors(24) = RGB(227- 227- 227)

Aspose.Cells Product Family
1

I’m able to save this macro only in “This workbook.”

Sub RGB()

ActiveWorkbook.Colors(24) = RGB(227, 227, 227)

' ThisWorkbook.Colors(24) = RGB(227, 227, 227)

End Sub

However when I add this function into the personal.xls file, I’m getting a compile error.

I need to use this function for many many reports and do not want to manually add this to each report.

Can you please help me to work around this issue?

Thank you

SKatz

2

Added VBA.RGB and it works

any other idea?

ActiveWorkbook.Colors(24) = VBA.RGB(227, 227, 227)

3

Hi,

Thank you for considering Aspose.

Well, I am not vary clear about your requirement. Can you please explain it in abit detail. Also it will be better, if you can share your sample code and template file in which you are getting problem. We will look into it. By the way which version of Aspose.Cells are you using? You can also download and try our latest version of Aspose.Cells for .NET V4.6.0.4.zip from the following post,

Thank You & Best Regards,