Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Silicon Valley, California, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Invalid qualifier for Err with Excel VBA (Excel 2000 SR1)

    Hi Folks,

    I wrote a simple Excel VBA routine for selecting files using Application.GetOpenFilename. There is an error handler as follows:

    <pre>ErrorTrap:
    Select Case Err.Number
    Case 13
    Exit Sub

    Case Else
    ' Some unexpected error, report it to user.
    MsgBox "ET Phone Home!"

    End Select ' Case Err.Number
    </pre>


    In my original template, it works fine. A colleagure copied it exactly into a project of his own, generated a template and sent it out. In his template, when the routine in question is invoked, we get a compilation error, "Invalid qualifier", with the Err highlighted.

    Furthermore, if I start typing "Err." in my code, the "auto-complete" list of properties and methods pops up, but if I do the same in his code, no context list pops up. What is happening here? Thanks!

    I will cross-post in the Excel forum.

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Invalid qualifier for Err with Excel VBA (Exce

    See my answer in the Excel Forum.
    Legare Coleman

  3. #3
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Invalid qualifier for Err with Excel VBA (Excel 2000 SR1)

    Thanks Legare for the reply in Excel.

    Any further response here please.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

Posting Permissions

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