Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Amersfoort, Netherlands
    Posts
    199
    Thanks
    4
    Thanked 0 Times in 0 Posts

    detect Excel version

    Hello All,

    Is it possible to detect the current running Excel version from VBA?
    I have a applictaion in Excel 2003 that will not work in Excel 2007 (because of home made menus and toolbars). And I want to show a message if a user opens the Excel document in the wrong version.

    Greetings,
    Patrick Schouten
    The Netherlands

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    5,911
    Thanks
    0
    Thanked 89 Times in 85 Posts
    Yes - Application.Version returns the version number (12 for Excel 2007 for example)
    Regards,
    Rory
    Microsoft MVP - Excel.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Amersfoort, Netherlands
    Posts
    199
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Thanks Rory,
    It works!

    greetings,
    Patrick Schouten
    The Netherlands

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •