Search the Community
Showing results for tags 'excel com'.
Found 1 result
-
Hopefully someone familiar with Excel COM in AutoIt will say "Oh, that's easy, you just..." Or if someone knows how to set the tab color with the Excel UDF, either way. specifying the hex directly works... $oExcelDoc.WorkSheets($Driver).Tab.Color=0x00FF00 declaring the variable directly works... $Acolor=0x00FF00 $oExcelDoc.WorkSheets($Driver).Tab.Color=$Acolor BUT... if my variable is set by output from functions or read from ini file (which is what i am trying to do) it doesn't apply the color... $Acolor=IniRead ( "Colors.ini", "A", "Color", "" ) $oExcelDoc.WorkSheets($Driver).Tab.Color=$Acolor I have quadruple checked that the ini is being read correctly and googled til my eyes popped out and have now gone mad.