copying macros

dariano · Apr 16th, 2002, 06:08 PM

I just got a new machine and want to copy all of my Excel macros (and custom buttons if possible) from my old box to the new machine. Is there an easier way to do this without re-recording the macros and recreating all of the custom buttons?

Any help would be greatly appreciated!!!

brettvba · Apr 16th, 2002, 06:11 PM

can't you just copy the file across

otherwise you can export the modules from the project explorer.

dariano · Apr 16th, 2002, 06:15 PM

The odd thing is that if I do a search for any of the macros (in explorer), there are no returned results. All of the macros are stored in the "personal" macro workbook in excel, and I can copy the personal.xls file over, but in order for me to access the macros, I have to start Excecl by opening the personal.xls file first!

dariano · Apr 16th, 2002, 06:46 PM

OK, I was able to copy the Macros over, but what about the custom buttons?

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

Apr 16th, 2002, 06:08 PM	#1
dariano New Member Join Date: Apr 2002 Posts: 3	I just got a new machine and want to copy all of my Excel macros (and custom buttons if possible) from my old box to the new machine. Is there an easier way to do this without re-recording the macros and recreating all of the custom buttons? Any help would be greatly appreciated!!!

Apr 16th, 2002, 06:11 PM	#2
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	can't you just copy the file across otherwise you can export the modules from the project explorer.

Apr 16th, 2002, 06:15 PM	#3
dariano New Member Join Date: Apr 2002 Posts: 3	The odd thing is that if I do a search for any of the macros (in explorer), there are no returned results. All of the macros are stored in the "personal" macro workbook in excel, and I can copy the personal.xls file over, but in order for me to access the macros, I have to start Excecl by opening the personal.xls file first!

Apr 16th, 2002, 06:46 PM	#4
dariano New Member Join Date: Apr 2002 Posts: 3	OK, I was able to copy the Macros over, but what about the custom buttons?