How to copy a Macro to another PC

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I find and copy an Excel macro to another PC. As I recall the one I
created also created a file called Personal.xls that automatically opens up.
Not sure if this is the only file that needs to be copied? Also, where does
it get copied to? What location? Same as original PC?
 
Personal.xls is automatically opened (if it exists) but is hidden; use
Widows | Unhide to see if you have one. Generally it is kept in the XLSTART
folder; find it with a search.

However, some people have Excel open other files automatically; Use Tools |
Options and look on the General tab to see if your Excel is set up this way.

Use Tools| Macros | VBA editor to check which file has the macro

Copy the file to the other PC and locate in the same folder.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with Personal.XLS and macros added to my toolbar 3
Copy range to multiple workbooks 2
Excel macro help needed to copy columns from one open excel toanother open excel, and shall run on a 5
running macros 2
Copy macro enabled button to another file 2
Making A Macro Generally Available 15
how to create word document based on data in excel 1
Get Name of Sheet to use in Macro 11

Back
Top