Referencing a cell color in different workbook

  • Thread starter Thread starter FireGeek822
  • Start date Start date
F

FireGeek822

I need to programmatically reference a cell in a different workbook
(Excel file). Once I reference that cell, I need to determine the
color and then change a cell in my current workbook to that exact
color. Example:

C:\ExcelFile1.xls
Column C
Row 33
Color is Blue

H:\Project\MasterPlan.xls
Column H
Row 40
Color needs to be Blue as it is in above workbook\cell.

Any thoughts? THANKS

Tammy
(e-mail address removed)
 
Will the workbooks be open? Assuming so


Workbooks("MasterPlan.xls").Worksheets("Sheet1").Range("H40").Interior.Color
index = _

Workbooks("ExcelFile.xls").Worksheets("Sheet1").Range("C33").Interior.Colori
ndex


--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Thanks Bob. My first try with this I used RGB( ) and didn't realize
the color index is a long number and doesn't use the traditional RGB
numbers.

Now I need to try to restrict all users of both workbooks to use only 6
specific colors.

I appreciate the help Bob, Thanks Again!!!

Tammy
 
Back
Top