View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ian Stanborough Ian Stanborough is offline
external usenet poster
 
Posts: 4
Default A program running on different Excel Versions

I have a program written on Excel 2003 and when i tried to run it on Excel
97, it would not compile correctly using the visual basic editor. I could
not find a command to differentiate between the two versions of EXCEL. I
wanted a command such that the appropriate code would be compiled for the
machine that i was on

#if EXCEL 2003 then
.....code
#else
#if EXCEL 97
... code
#end
# end


any suggestions?