Results 1 to 5 of 5

Distributing Excel Modules

This is a discussion on Distributing Excel Modules within the Excel Questions forums, part of the Question Forums category; This board has been extremely helpful in educating me on how to distribute macros. But I can't seem to find ...

  1. #1
    Board Regular
    Join Date
    May 2002
    Location
    San Diego
    Posts
    154

    Default Distributing Excel Modules

    This board has been extremely helpful in educating me on how to distribute macros. But I can't seem to find any information on distributing modules.

    I have an Excel workbook with a module in it that I'd like to make available to about 30 users. Since we are not all on the same network, I'd like them to add the code to their versions of Excel (we all use Excel XP). Since a good number of these users are novices, I'd like to keep this as simple as possible.

    Ideas would greatly be appreciated!

    Thanks!

    Mark

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,948

    Default Re: Distributing Excel Modules

    You should try to create Addin(s) and send it to those users.
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    Board Regular
    Join Date
    May 2002
    Location
    San Diego
    Posts
    154

    Default Re: Distributing Excel Modules

    Thanks, Juan.

    I actually did create an Add-In and Added it. But afterwards I couldn't find it or figure out how to launch it. With a macro I know you go to Tools/Macros/Macro and then type in the macro name after installing an Add-In. But this didn't work for the module.

    How do I tell a user how to launch it after they add the Add-In?

    Mark

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,948

    Default Re: Distributing Excel Modules

    Well, basically, that is something you have to do too.... take a look for example at the HTML Maker Add In (Link is at the bottom). That file has a routine that adds a menu, enabling the user to use it directly from Excel, without having to do the Alt F8 thing...
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  5. #5
    Board Regular
    Join Date
    May 2002
    Location
    San Diego
    Posts
    154

    Default Re: Distributing Excel Modules

    Thanks again, Juan.

    I took a look at HTML Maker -- and everything else on the page -- but couldn't find any references to modules or menus. But after looking through everything, it helped me to change the direction I'd like to go.

    What command do you use in a macro to call a module?

    I'll have to do some research, but I'm thinking I could distribute a toolbar as part of the add-in that has a button assigned to the macro that calls the module. Does that make sense? It's much better than making the user use Alt-F8 and run the macro. I'll have to figure out how to distribute a toolbar as part of an add-in and how to assign a macro to a button on the toolbar, but the first step will be figuring out how to all the module from the macro.

    Suggestions on how to do this better encouraged!

    Mark

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com