moving macros to other machines (personal.xls?)
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: moving macros to other machines (personal.xls?)

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

    Default

     
    I'm kicking myself...
    I need to set up my macro on someone else's computer and their "personal.xls/personal macros folder" isn't available. a message box used to ask me if i wanted to add it to personal, but i'm not getting that option on this machine. Hell, i'm not even sure if copy/pasting the text from the macro or exporting/importing it to the other machine is a better opt. (never done it before)
    Any help/dirx is much appreciated!!!

  2. #2
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How about saving you personal.xls as an add-in and moving the add-in to their machine. (do a "Save As" and change *.xls to *.xla, or scroll down to the last option in the FileType combobox)

    On the other machine open Excel and go to Tools|Add-ins... and browse to the location of the Add-in.

    HTH

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    if your networked be care ful IT might over right this ...

    macro crunching i guess.. this is common

    REMEMBER to export bas files of all cripts for safty....


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    also cls and userforms

    a must...


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  5. #5
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Typically, even on networks, you're looking for a folder on the c: drive (use the explorer) called "xlstart." Paste the file to this directory (note: it doesn't necessarily need to be named "personal.xls").

    Hope this helps.

    _________________
    Cheers, NateO
    "Me no are no nice guy"

    [ This Message was edited by: NateO on 2002-04-19 11:20 ]

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

    Default

    Right click on the module that contains the macro and use export.


    Regards,

    Gary Hewitt-Long

  7. #7
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanks to all for your help! I really appreciate it!

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
  •  

 

 
DMCA.com