Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Apr 2002
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sharing Macros (Excel 97)

    I've created some extensive macros. When I tried to install the Personal.xls file in my managers system using the same path as mine, it didn't work.

    I know now on a few of the macros I should put them on a template so the rest of the department can use them in our shared drive. Not sure how to copy them. Do I need to recreate them?

    Several of them can't be put on a template as we import files and then the macro must be run with the new file. How do I share these macros?

    Thank you!

  2. #2
    Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sharing Macros (Excel 97)

    The best way I know of sharing macros is to put them in an add-in. Then anybody can read them from a shared drive.

    To create an add-in from your personal.xls is easy. Open it up and then do SaveAs, and select the file type Microsoft Excel Add-in (*.xla) (It's right down the bottom of the list, of course).

    If you save that to a shared drive, then users can access it by going to the Tools menu, selecting Add-ins and then Browse. Once they have found your add-in and selected it, Excel will ask something like "Copy to Add-in Library?". If you say no, then they will always access the copy of the add-in on the shared drive, which makes it easy to update with new macros. If you say yes, then the add-in gets copied to Crogram filesmicrosoft officeofficelibrary, and updating with new versions becomes a pain.

    All macros in the add-in will be available to all workbooks that are open. However, the add-in macros will not appear in the Tools>Macros list. Generally with add-ins being distributed around the office/country, we get the add-ins to create their own menus for the macros available to users.

    Does that help?

    Jon

  3. #3
    2 Star Lounger
    Join Date
    May 2001
    Location
    Omaha, NE USA, Nebraska, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sharing Macros (Excel 97)

    It certainly helped me. Thanks Jon.

    I stumbled my way through creating an add-in and it works great, but I have constantly been running around <img src=/S/sick.gif border=0 alt=sick width=15 height=15> updating several other users pcs. Now that I now about the shared directory piece, I will be implementing that on Monday.

    What a time saver. <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>

Posting Permissions

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