try:-


ver = Application.Version

select case ver
case 10
' code for XP here
case 9

case else

end select

--
Patrick Molloy
Microsoft Excel MVP
----------------------------------
wrote in message
...
How do I determine the version of Excel one is using?

I am opening a text file and found out that the code is different
for Office 97 and Office XP. So I now need an IF statement

If (XLversion = 97) Then

End iF

If (XLversion = XP) Then

End If


Lance