Results 1 to 2 of 2
  1. #1
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Which Version of Excel?

    G'Day All,

    I am writing some fairly simple vba macros but sometimes I use vba2000 items (fso or userforms) that don't work with excel 97 - sigh.

    Is there a way of telling which version of excel the macro is running under?

    I'm sure that this question has been asked before but I couldn't find it via the search option. Is there an archive that I needed to search as well?

    Cheers,

    Tim
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

  2. #2
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts

    Re: Which Version of Excel?

    Hi Tim,

    All you need is "Application.Version".

    BTW, this is a real longshot, but you wouldn't happen to be the Timbo who does the surf forecasts on RealSurf.com, would you?

    Gary (avid but geographically misplaced surfer)

Posting Permissions

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