Colour Palettes

[Graham]

Hi
I have received a Powerpoint 2003 slide deck from a client that contains a
colour palette they would like me to use. I would like to be able to easily
replicate this colour palette in either Excel 2003 or Excel 2007. Is there a
way of transferring a colour palette from Powerpoint to Excel?
Thanks
Graham

 

[Steve Rindsberg]

Hi
I have received a Powerpoint 2003 slide deck from a client that contains a
colour palette they would like me to use. I would like to be able to easily
replicate this colour palette in either Excel 2003 or Excel 2007. Is there a
way of transferring a colour palette from Powerpoint to Excel?
Thanks
Graham

PPT doesn't have palettes; 2003 and earlier use Schemes, which contain only 8
colors. Choose Format, Slide Design. Click "Color schemes" in the panel that
opens on the right then "Edit color schemes" to open the scheme editor for the
current slide. Doubleclick any of the scheme colors and you'll be able to get
the RGB values for the color on the Custom Colors tab.

This snippet will give you the Long values representing the RGB color of each
scheme color:

Sub thingie()
Dim x As Long
With ActiveWindow.Selection.SlideRange(1)
For x = 1 To .ColorScheme.Count
Debug.Print .ColorScheme.Colors(x).RGB
Next
End With
End Sub