Results 1 to 4 of 4
  1. #1
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    What is version of VBA EXtensibility file? (Office XP)

    Looking at the project references, the file seems to be titled

    Microsoft Visual Basic for Applications Extensibility 5.3
    VBE6EXT.OLB is version 6.0.91.8.

    Is that correct for Office XP?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: What is version of VBA EXtensibility file? (Office XP)

    In Excel 2002, WindowsXP running (with a reference set to Visual Basic for Applications Extensibility) <pre> Dim refVBE As VBIDE.Reference
    For Each refVBE In ThisWorkbook.VBProject.References
    Debug.Print refVBE.Name, refVBE.Major, refVBE.Minor, _
    refVBE.FullPath, refVBE.VBE.Version
    Next refVBE</pre>

    returns

    VBIDE 5 3 C:Program FilesCommon FilesMicrosoft SharedVBAVBA6VBE6EXT.OLB 6.03

    VBA Version is 6.3.8863., Forms 3:2.01

    Interestingly changing the reference to to Microsoft Visual Basic 6.0 Extensibility (Need to remark out the Dim statement). , I get the same result, except for the path. The actual files have the same name (VBE6EXT.OLB), but different dates and filesize.

    Andrew C

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: What is version of VBA EXtensibility file? (Office XP)

    Keep in mind that VB6 was released prior to Office 2000. The VBE files for Office XP were updated.
    Charlotte

  4. #4
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: What is version of VBA EXtensibility file? (Office XP)

    My query was not related to VB, just VBA.

    VBA in Office XP is 6.3, so it is confusing to have the reference named with 5.3.

Posting Permissions

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