+ Reply to Thread
Results 1 to 10 of 10

XLQUERY.XLA!Register.DClick Problrm

  1. #1
    Registered User
    Join Date
    07-30-2004
    Posts
    20

    Question XLQUERY.XLA!Register.DClick Problrm

    Everytime I open a file that has a database query set up, I get this message:

    Cannot find XLQUERY.XLA!Register.DClick, which has been assigned to run each time <filename> is opened. Continuing could cause errors. Cancel opening <filename>?
    Yes or No

    This just started happening a few weeks ago, does anybody know about this problem?

    Thanks,
    Moe

  2. #2
    Registered User
    Join Date
    07-30-2004
    Posts
    20
    I'm sure I'm not the only one with this problem. Anyone??

  3. #3
    Registered User
    Join Date
    07-30-2004
    Posts
    20
    Anybody? I'm still having this problem several months later.......

    Thanks

  4. #4
    Registered User
    Join Date
    10-26-2005
    Posts
    1

    I feel your Pain

    I am having the same error...I have found a site that explains the error and gives suggestions, but at this point I have not been able to decifer what I need to do exactly. Maybe you will have better luck.

    http://support.microsoft.com/default...b;en-us;277620

  5. #5
    Registered User
    Join Date
    02-06-2004
    Posts
    2
    Did nobody ever figure out how to fix this? I have had this problem for months too.

  6. #6
    Registered User
    Join Date
    01-06-2006
    Posts
    1

    This error sucks!!!

    I am having the same problem. I havent found a solution yet. I can tell you this though if you are running Excel 2002 or 2003 it does not include the Xlquery.xla file and according to their website is no longer available for download. You need the file to put in the following directory.
    C:\Program Files\Microsoft Office\Office\Library\MSQuery

    But if you cant download the file anywhere than how do you fix it? This is stupid.

  7. #7
    Registered User
    Join Date
    11-12-2008
    Location
    Godhra, Gujarat, India
    Posts
    1
    open vba (alt+f11)
    dbclick vbproject(<yourfilename>)
    dbclick microsoft excel object
    dbclick this workbook
    pest following code

    Please Login or Register  to view this content.
    run thiscode
    delete thiscode
    close vba
    save the file

    Gitesh
    Last edited by VBA Noob; 11-12-2008 at 03:47 AM. Reason: Added code tags as per forum rules

  8. #8
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Gitesh Shah,

    Welcome to the forum.

    Please take a few minutes to read the forum rules below before posting again. I've added the code tags for you this time.

    Also we prefer you don't dig up old threads as the OP would already have found a solution

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  9. #9
    Registered User
    Join Date
    09-07-2012
    Location
    Helsinki, Finland
    MS-Off Ver
    Excel 2010
    Posts
    1

    Cool Re: XLQUERY.XLA!Register.DClick Problrm

    I got the problem solved with this VBA module:
    Sub DeleteQueryDefinedNames()
    Dim n As Name
    For Each n In ActiveWorkbook.Names
    If n.Visible = False And InStr(1, n.Name, "QUERY", _
    vbTextCompare) > 0 And InStr(1, n.Name, _
    "Query_from", vbTextCompare) = 0 Then
    n.Delete
    End If
    Next
    End Sub


    :-) Lennart L.

  10. #10
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO200;Win10/MSO2016
    Posts
    9,866

    Re: XLQUERY.XLA!Register.DClick Problrm

    Welcome to the forum.

    Please take a few minutes to read the forum rules below before posting again....

    Also we prefer you don't dig up old threads as the OP would already have found a solution ( see #8 above)
    -------------------------
    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1