Excel 2007, VBA/VB6: Read the different colors defined for a workbook...
 

Hi everybody,

i have to make my own color picker in VBA/VB6... There are three sections in
the standard color pickers: Theme colors, default colors and recent
used/user defined colors. I puzzled out that theme colors are stored at for
e.g. Workbook.Theme.ThemeColorScheme(1..10).RGB - this gives me the 10 main
colors. Beside that there are five tinted/shaded colors for each main
color - it seems that this colors are not stored anywhere, thus they have to
be calculated based on the main color, for e.g.: Convert RGB to HSL: L=L- 5%
or L=L +50%, convert HSL back to RGB - is this really they way to go or have
i missed something? Next question: The recent used/user defined colors
seemed to be stored with the workbok, you can have different recent
used/user defined colors for each workbook - where exactly are the infos
(number of colors defned, RGB values) stored in the workbook/object modell?
Thanks for any hint!

--

Bis dann, Bomi