View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Disable 2003 VB code for users using older Excel

To avoid problems use in non US systems use

If Val(Application.Version) < 10

In Dutch it is 10,0 instead if 10.0 for example



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
Typo.......missed a double-quote after Excel

MsgBox "This utility will not work in your version of Excel", vbExclamation


Gord

On Fri, 28 Sep 2007 17:39:19 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

If Application.Version < "10.0" Or Application.Version < "11.0" Then
MsgBox "This utility will not work in your version of Excel, vbExclamation
End
End If