VBA version

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

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
 
Harald Staff said:
If I understood Dave B correctly, Macintosh versions are still VB5.
Click to expand...

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

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

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...
 
Back
Top