I am developing a solution to operate on multiple versions of Office
and in multiple languages. The code I have written needs to read and
write information to named ranges in Excel using comma separated
information. I have a language version that uses semi-colon in place
of comma to separate information. Using the
Application.International(xlListSeparator) property I can get the
correct separator to use. This works fine in VBA 5 but for VBA 6 the
language of the code is always used, so I always need to pass comma.

My question is how can I get the VBA version so I can apply the
correct list separator?

I know I can use the Application.Version property to get the Office
version, but I know of some versions of Office 97 running VBA6.