Copy a Macro

P

Phil K

I developed a macro on my home workstation, I can't seem to find how to copy
or "transport" the macro to my office workstation. I saved the macro in the
Personal Work Book (Personal.xls). Any help would be appreciated.

Phil
 
N

Norman Jones

Hi Phil,

Copy/paste the macro into the body of an email. Send the email, containing
the text copy of the macro, to your office. When back in the office, copy
paste the macro text from the email into a a module on your office pc.
 
P

Phil K

Thanks Norman

Norman Jones said:
Hi Phil,

Copy/paste the macro into the body of an email. Send the email, containing
the text copy of the macro, to your office. When back in the office, copy
paste the macro text from the email into a a module on your office pc.
Click to expand...
 
D

Dave Peterson

I tried to use the same personal.xl* file at home and at work. I'd just keep an
up to date copy at each location.

If I changed the one at work, I'd copy it and install it at home. And if I
changed the one at home, I'd copy it and install it at work.

As well as update both location's backup copies.
 
Top