Excel cell colors into Access table
Posted on 2014-11-05
I have a monthly excel workbook files for several years, each with 1-31 worksheets. Each worksheet is a daily schedule with 10 machines as columns B-K and 30 minute time slots between 8AM and 10PM as rows 4-32. Each day essentially has 280 data elements. When the machine is used the cell color is changed to one of several colors depending on the process that was used.
I need to get this data into an MS Access table for analysis.
Table structure is : ID, DateTime, MachineNo, ProcessNo
I think I can loop through the worksheets, then the cells but how do I read the cell color using vba and scan the data?
Thanks in advance.