ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Copy a Macro (https://www.excelbanter.com/excel-discussion-misc-queries/29870-copy-macro.html)

Phil K

Copy a Macro
 
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



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.

---
Regards,
Norman



"Phil K" wrote in message
...
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





Phil K

Thanks Norman

"Norman Jones" wrote:

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.

---
Regards,
Norman



"Phil K" wrote in message
...
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






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.

Phil K wrote:

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


--

Dave Peterson


All times are GMT +1. The time now is 08:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com