moving macros to other machines (personal.xls?)

[captka]

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!!!

 

[Mark O'Brien]

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

 

[Jack in the UK]

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....

 

[Jack in the UK]

also cls and userforms

a must...

 

[NateO]

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,<font size=+2><font color="red"> Nate<font color="blue">O</font></font></font>
"Me no are no nice guy"
This message was edited by NateO on 2002-04-19 11:20

 

[gplhl]

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

 

[captka]

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