+ Reply to Thread
Results 1 to 13 of 13

question about addin and a special function

  1. #1
    Registered User
    Join Date
    05-29-2013
    Location
    hk
    MS-Off Ver
    Excel 2007
    Posts
    11

    question about addin and a special function

    https://www.dropbox.com/s/tckgvxtf06...0V3.xls?v=0mcn

    in sheet "numex" cell d38, what is function "table" ? where can i find it?




    and, https://www.dropbox.com/s/sotfva69vd...est.xls?v=0mcn

    in sheet "Intro", cell A12, i cannot find the addin bfes_interest.xll , anyone know where it is?


    i am new in excel, can anyone help ?

    thanks!!!!

  2. #2
    Registered User
    Join Date
    05-29-2013
    Location
    hk
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: question about addin and a special function

    can anyone help? thanks!

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,563

    Re: question about addin and a special function

    The people on this forum tend to prefer that you upload your files to this forum. They don't like going out to services like dropbox to retrieve files.

    I don't know if 2007 works the same as my older version. When UDF's from an add-in are used in my version, they will show up in the "edit links" dialog http://office.microsoft.com/en-us/ex...348.aspx?CTT=1 In my version, you can find path and filename for the add-in containing the UDF's.

    You might also be able to find that information in the manage add-ins dialog http://office.microsoft.com/en-us/ex...127.aspx?CTT=1

    If the function is coded in VBA, you can press alt-F11 to bring up the VBA editor. Then, navigate through the available projects until you find the one that contains the UDF.

    From there, you will probably have to upload a file.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  4. #4
    Registered User
    Join Date
    05-29-2013
    Location
    hk
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: question about addin and a special function

    Hi Mrshorty,
    thank you very much. i tried to edit it and attach file. but i fail. is it my limit of authouity?
    would you mind having a look in my template?
    I cannot find the Macros for the UDF. do you mean the "table" function is user defined function?
    also, where can i find this bfes_interest.xll addin file?

    I am not familiar with it. Thank you for your help!

  5. #5
    Registered User
    Join Date
    05-29-2013
    Location
    hk
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: question about addin and a special function

    i rewrote a new thread
    http://www.excelforum.com/excel-gene...22#post3258122

    hope you can help

  6. #6
    Registered User
    Join Date
    05-29-2013
    Location
    hk
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: question about addin and a special function

    can anyone help ? thanks!

  7. #7
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,563

    Re: question about addin and a special function

    From the intro page to the bfes file, I put "Richard Stanton BFES excel add-in" into my favorite internet search engine and found a download from Berkeley's website for the file. If you cannot find the file on your system already, you might try downloading it again.

    I could not find any indicator, description, or anything for the "TABLE()" function.

  8. #8
    Registered User
    Join Date
    05-29-2013
    Location
    hk
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: question about addin and a special function

    thanks! would you mind giving me the link here? i use google search but i can't find it

  9. #9
    Registered User
    Join Date
    05-29-2013
    Location
    hk
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: question about addin and a special function

    yes i found it!!!! thanks!!!

  10. #10
    Registered User
    Join Date
    05-29-2013
    Location
    hk
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: question about addin and a special function

    although i can use the function after installing the addin, do you know how can i see the logic/calculation step behind the function? i didn't see it in Macros

  11. #11
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,563

    Re: question about addin and a special function

    To view VBA code, you need to open the VBA editor http://office.microsoft.com/en-us/ex...374.aspx?CTT=1 see the section "create a macro by using VBA" in the middle of the page. Once you have the VBA editor open, you should be able to use the Project Explorer to find the add-in with its modules, then navigate through the modules to find the function you are interested in.

    This all assumes that Dr. Stanton did not password protect his project, in which case you will have to contact him to ask about permission to view the code.

  12. #12
    Registered User
    Join Date
    05-29-2013
    Location
    hk
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: question about addin and a special function

    i searched the modules, i didn't find the function. i think he didn't use VBA to write the function. do you know how to open xll file?

  13. #13
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,563

    Re: question about addin and a special function

    I would guess that xll, similar to a dll, could be a compiled file that does not have the source code in it in a readable format. You could try using a text editor (like notepad or wordpad) to open the xll and see if there is an readable text. If that doesn't work, then I expect you will have to talk to Dr. Stanton to see if he will share the source code with you.

+ 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