+ Reply to Thread
Results 1 to 3 of 3

import excel module

  1. #1
    Registered User
    Join Date
    11-15-2007
    Posts
    5

    import excel module

    I have written a module to add some extra functionality to excel formulas

    e.g.

    new formula
    =cuberoot(A1)
    will not take the value of A1 and return the cube root

    I have exported this module as a .bas file

    I would now like to give people a shortcut which will load this module into their excel for use with any future sheets without have to load the module everytime they want to use it.
    Is there a global module import that I can use, say in the excel prefences or a way I can send people a link to the file to auto import into excel

  2. #2
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161
    You would need to create an .xla file the xla file is an add-in file, for a step by step easy to understand way of creating an add-in go here!
    Not all forums are the same - seek and you shall find

  3. #3
    Registered User
    Join Date
    11-15-2007
    Posts
    5
    thanks, this looks very helpful

+ 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