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.

Excel 2000-2003 are using VBA6

You can use this also to test

Sub Test()
#If VBA6 Then
'code
#Else
'code
#End If
End Sub





--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Matt" wrote in message om...
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.

"Ron de Bruin" wrote in message
...
Excel 2000-2003 are using VBA6

If I understood Dave B correctly, Macintosh versions are still VB5.

You can use this also to test (...)

Should make sense to the iFruits also.
(OT but recommended: http://homepage.mac.com/giantmike/ifruit.html )

Best wishes Harald
Followup to newsgroup only please.

In article ,
"Harald Staff" wrote:

"Ron de Bruin" wrote in message
...
Excel 2000-2003 are using VBA6

If I understood Dave B correctly, Macintosh versions are still VB5.

Yup. Likely will stay that way since VBA is about to be a dead
language...


You can use this also to test (...)

Should make sense to the iFruits also.
(OT but recommended: http://homepage.mac.com/giantmike/ifruit.html )

This one is my favorite:

http://homepage.mac.com/giantmike/pics/ifruit/69.gif

I always wondered whether the author knew what was meant in the
final frame of

http://homepage.mac.com/giantmike/pics/ifruit/40.gif

Seems to me CHMOD 770 * would be much more fun...