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