+ Reply to Thread
Results 1 to 3 of 3

How to attach a code module to a group of workbooks?

  1. #1
    keithb
    Guest

    How to attach a code module to a group of workbooks?

    Is there a way to use a common code module and attach it to more than one
    workbook? If so, how do you make its procedures and funtions available to
    the workbook and the worksheets in the workbooks where it is attached.

    Thanks,

    Keith



  2. #2
    Registered User
    Join Date
    03-03-2005
    Location
    UK
    Posts
    26

    xla

    Hi Not sure if this is what you want but

    If you put all of your code into one workbook and then save it on the save as menu select xla rather than an xls and save it as a .xla

    This will save it as and excel add-on.

    Then this add-on should load with excel everytime. You can the call the methods from and workbook and even have custom menus that call menus. On the menus just type the method name mymethod() or call it in code Call mymethod()

    I have my own set of functions that i use as well as the excel standard ones.

    Hope This Helps


  3. #3
    Bob Phillips
    Guest

    Re: How to attach a code module to a group of workbooks?

    No, but you code put the code in an add-in. Then you run the code in the
    add-in like so

    Application.Run "myaddin.xla"mymacro"

    --
    HTH

    Bob Phillips

    "keithb" <[email protected]> wrote in message
    news:%[email protected]...
    > Is there a way to use a common code module and attach it to more than one
    > workbook? If so, how do you make its procedures and funtions available to
    > the workbook and the worksheets in the workbooks where it is attached.
    >
    > Thanks,
    >
    > Keith
    >
    >




+ 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