View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
FireGeek822 FireGeek822 is offline
external usenet poster
 
Posts: 8
Default Referencing a cell color in different workbook

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