PC Review


Reply
Thread Tools Rate Thread

How to copy a Macro to another PC

 
 
=?Utf-8?B?Rkw=?=
Guest
Posts: n/a
 
      28th Mar 2007
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?
--
FL
 
Reply With Quote
 
 
 
 
Bernard Liengme
Guest
Posts: n/a
 
      28th Mar 2007
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.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"FL" <(E-Mail Removed)> wrote in message
news:AAD5EF0D-E4C2-45F6-A4F5-(E-Mail Removed)...
> 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?
> --
> FL



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to copy a sheet and delete a macro button JoeP Microsoft Excel Programming 8 30th Sep 2009 07:14 PM
Change a Macro - Copy in Columns instead of copy in Rows ytayta555 Microsoft Excel Programming 7 9th May 2009 07:32 PM
Macro to copy and paste values (columns)I have a macro file built C02C04 Microsoft Excel Programming 2 2nd May 2008 02:51 PM
Sorry, No Word Macro Forum. Macro To Search And Copy All Occurances bsmith27 Microsoft Excel Programming 0 25th Apr 2008 03:41 PM
how to count/sum by function/macro to get the number of record to do copy/paste in macro tango Microsoft Excel Programming 1 15th Oct 2004 02:16 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:57 PM.