combine macros from 2 personal.xls

J

jsmonje

is there a way to "merge" the macros from 2+ personal.xls files. I hav
MANY that contain unique macros, and i am looking for a good way to pu
them all together and the use one pesonal.xls for all my machines. M
bad due to poor housekeeping practices.....

thanks in advance
joh
 
S

swatsp0p

I would rename all but one of my personal.xls files as such: personal 1.xls,
personal 2.xls, etc.

Put all of these files along with just one called personal.xls in my
"XLStart" folder.

Open Excel, open VBA editor (Alt+F11), open each Project and copy the
contents to the one personal.xls file.

Save and close Excel (clicking "yes" to save personal.xls)

move or delete the previously renamed personal ?.xls files.

HTH

Bruce
 
D

Dave Peterson

I'd rename them to pers1.xls and pers2.xls.

then open each.

Create a new workbook (that will be called personal.xls) and copy|paste modules
(or subroutines from each module) into the new workbook's project.

Save the new personal.xls into your XLStart folder and remove (don't delete!)
the other pers*.xls files from there.

If you realize that you didn't get them all copied, just open up the workbook
that contains the missing code and copy|paste into personal.xls.
 
Top