Results 1 to 7 of 7
  1. #1
    dmitri
    Guest

    Unexpected #Name error (XP)

    I'm getting a very strange error. I have an .XLL file with a number of functions in it. I have one particular spreadsheet I'm working with where some of the functions from that XLL work just fine and some produce a #Name error. The formulas that produce the #Name error show up in the Function WIzard and, the weirdest part of it, work just fine in other spreadsheets. I can't figure out what makes this spreadsheet different.
    The function that doesn't work is pretty simple. It takes two strings as parameters and returns a double.
    One more note, all functions in this XLL used to reside in an XLA and have been moved to an XLL for speed. The spreadsheet that doesn't work used to work with an XLA and has been repointed completely to the XLL. All XLA's have been removed from the system and there are no path names in formulas.
    I'm completely lost here. I wonder if anyone has any ideas.

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Unexpected #Name error (XP)

    I can not answer your question, but I do have one of my own. What does an XLL do?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    dmitri
    Guest

    Re: Unexpected #Name error (XP)

    An XLL is essentially a DLL where you can write formulas in C accessible from XL. Those formulas can be setup to show up in function wizard just like any other formula. Writing them in C makes them significantly faster than the ones written in VBA.

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unexpected #Name error (XP)

    Would it help to reference the xll in the workbook in question (VBE, Tools, References)?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    dmitri
    Guest

    Re: Unexpected #Name error (XP)

    No, that doesn't work. We were able to find a workaround by creating a differen alias for the same function in the xll and that worked. It's still pretty weird.

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

    Re: Unexpected #Name error (XP)

    Could you possibly be using XL reserved words for those names?
    Legare Coleman

  7. #7
    dmitri
    Guest

    Re: Unexpected #Name error (XP)

    Not unless DBXLInstrumentPosition is a reserved name.

Posting Permissions

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