PDA

View Full Version : Solved: excel2000 question



vzachin
06-10-2008, 01:05 PM
hi,

i have a piece of code that will work on excel2003 but will not work in excel2000 because the feature is not there.
how can i incoporate into the code to check the version of excel running?


if excel2003 then
Worksheets("sheet1").tab.ColorIndex = 5
end if

when i write code using excel2003, is there any (aside from running the code in an older version) to know that the code will fail?

thanks
zach

mdmackillop
06-10-2008, 01:13 PM
Check out this KB item (http://www.vbaexpress.com/kb/getarticle.php?kb_id=336)

vzachin
06-10-2008, 05:53 PM
thanks malcolm
just what i needed