View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default hope someone can help with excel save with 2003 and 2007 installed on my computer

sparks was thinking very hard :
it runs but like I said I only get xls type of output so I don't know
if 2003 or 2007 is running...how do I tell?


Set oExcel = CreateObject("Excel.Application")


If oExcel.Version < 12 Then '//it's 2003 or earlier
'process as early
Else '//it's 2007 or later
'process as latest
End If

Why do you need the path? The OS knows which Excel version to run!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc