Converting 2007 VBA color patterns to 2003 color patterns

I have some code in Excel 2007 and I want it to be compatable with 2003. How would I go about finding what the similar command is in 2003 which will create similar cell background colors to this

Please Login or Register  to view this content.

Is there a website that will give approximate matches?
Thanks in advance.

Hello ChemistB,

Are you trying to match 2003 colors to 2007 colors or are you looking for the cell properties in 2003 that correspond to those in 2007?

I guess I would need both. I realize that 2007 has lots more colors so probably won't get an exact match. I wrote the code in 2007, partially using the macro command, and I want it to be compatable with 2003. If I have to change the colors slightly, that's not a big deal. Thanks

Hello ChemistB,

I haven't done this in awhile but you can copy an Excel color palette. If I remember correctly, a file is created. You could then import the file into Excel 2007, unless there have been some major changes. I need to look into it to be sure.

Hello ChemistB,

Copying the color palette hasn't changed. You can manually copy the Excel 2003 to your Excel 2007 workbook manually.

Copy a color palette to another workbook

1. Open the workbook that contains the color palette you want to copy.
2. Switch to the workbook that you want to copy the color palette to.
3. On the Tools menu, click Options, and then click the Color tab.
4. In the Copy colors from box, click the workbook that contains the color palette you want to copy, and then click OK.

That would work if I had a copy of Excel 2003. I'm thinking if I had 2003, I could simply record a macro with similar colors and see if they transfer directly into 2007.

Hello ChemistB,

I have created a text file with the Excel 2003 palette. This macro will import the file into the Active Workbook and reset the colors to those in Excel 2003.

Please Login or Register  to view this content.

Wow, thanks Leith! Will check it out today.

I get a compile error (see attachment)

See the attachment: colors, colorindexes, RGB and Hex:

Thanks snb, very helpful as usual. This will be a good file to keep around.

Hello ChemistB,

Not sure why you got that error. The named argument "InitialFileName" is the same in both Excel 2003 and 2007. Did you try reloading and running the macro again?