moving macros to other machines (personal.xls?)

captka · Apr 19th, 2002, 09:37 AM

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 · Apr 19th, 2002, 10:50 AM

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 · Apr 19th, 2002, 12:15 PM

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 · Apr 19th, 2002, 12:16 PM

also cls and userforms

a must...

NateO · Apr 19th, 2002, 12:19 PM

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 ]

gplhl · Apr 19th, 2002, 12:28 PM

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

captka · Apr 30th, 2002, 09:09 AM

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

Apr 19th, 2002, 10:50 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	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 __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Apr 19th, 2002, 12:15 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	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"

Apr 19th, 2002, 12:16 PM	#4
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	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"

Apr 19th, 2002, 12:28 PM	#6
gplhl Board Regular Join Date: Feb 2002 Location: Chippenham, UK Posts: 136	Right click on the module that contains the macro and use export. __________________ Regards, Gary Hewitt-Long

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 19th, 2002, 09:37 AM	#1
captka New Member Join Date: Apr 2002 Posts: 2	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!!!

Apr 19th, 2002, 12:19 PM	#5
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	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 ]

Apr 30th, 2002, 09:09 AM	#7
captka New Member Join Date: Apr 2002 Posts: 2	Thanks to all for your help! I really appreciate it!