Quote:
Originally posted by ray705
There are significant differences between Office 95 and 97. Some of the code will work but if you use and API calls, they will not work. You may end up with having to maintain multiple sets of code.
|
If multiple set's of code are needed, then it might make life a little easier to use a select case on the Version Property and for each case call the appropriate routine.
Select Case Application.Version
Case "Excel 95", "Excel 97" 'or whatever the value returned
Call CodeForExcel9597
Case "Excel 2000"
Call CodeForExcel2000
Case Else
Call CodeForExcel9597 'Assuming lowest level should work for everything
End Select
Again, I don't know what values are returned for any of the versions of Excel, but it shouldn't be hard to figure out. BTW, Version Property is a String.