Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: "Master (Callable) Macro File"

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is there anyway to use a macro from another spreadsheet in the current open spreadsheet?
    I have about 9 files using pretty much the same functions, and when I want to update any of the functions I have to update all of the macros on 9 files to keep them in sync.
    I think if I put all of the macro functions in one callable macro xls file, I can just set my other macros to call that file so I can update in one place.

    Any Ideas anyone?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Chippenham, UK
    Posts
    144
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Stick the Macro in your personal file

    Personal.xls

    Regards,

    Gary Hewitt-Long

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Not sure what you mean. First of all I never used a "personal file" . But lets say I had a personal.xls. Where would I store it? Second , these excel files are on a server, so I have different people accessing them, so would I have to put my "personal.xls" file on the server?
    And third, how would I call the functions from it's macro?

    _________________
    Give a carpenter a tool and he'll build a house, give a scientist a lab and he'll make a cure, give me a computer and I'll build you your application...

    [ This Message was edited by: moex201 on 2002-03-06 07:53 ]

Some videos you may like

User Tag List

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
  •