Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excel FormatConditions
#1
In QM 2.3.2.3

Error (RT) in exceltest: type mismatch

ExcelSheet es3.Init("" 8)
Excel.Range r=es3.ws.Range("G:G")
r.FormatConditions.Add(Excel.xlCellValue Excel.xlLess 25)
r.FormatConditions.Item(1).Font.ColorIndex=3
r.FormatConditions.Item(1).Font.Bold=TRUE

in older versions worked, do you know why?
#2
Works well with my Office 2003.
Where exactly is the error?
#3
I'm using

Windows 2000
Microsoft Excel 2000

error in r.FormatConditions.Add(Excel.xlCellValue Excel.xlLess 25)
#4
I'm sorry. I reboot the computer and now it works.


Forum Jump:


Users browsing this thread: 3 Guest(s)