Does anybody have any experience with loading the color from a range of Excel cells? I have found this example which uses VBscript (http://www.meadinkent.co.uk/excel-color-calcs.htm) and works but it can only be applied to a single cell in the same worksheet. I have serveral worksheets with different ranges (both in columns and rows) of coloured cells, so I'm looking for a more scaleable solution.
Have no experience, but within VB it is possible to open an instance of Excel, reawrd each cell individually, apply a formula - like the quoted ones - and to pick the cells one-by-one. Alternatively the entire manipulated Excel might be saved under temporary name and then read as entire file into QV.
Wouldn't it be easier to write a macro in Exel-VBA, which does the required manipulation?