Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
var = 'SumProduct((RNG="books") * (REGION=6101) * (UNITS))' ;var = 'SumProduct((( RNG="books")+( RNG="pet")) * (REGION=6101) * (UNITS))' nUnits = oXL.Evaluate(var)Note: 'evaluate' appears nowhere in the Excel Help file. It appears 'evaluate' method functions at both the application and worksheet level and will work on strings up to 256 chars).
Article ID: W16621
File Created: 2005:02:18:12:21:38
Last Updated: 2005:02:18:12:21:38