1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Can I Transfer An Excel Macro To Another Computer?

Discussion in 'Business Applications' started by mickeyw3340, Oct 28, 2005.

Thread Status:
Not open for further replies.
Advertisement
  1. mickeyw3340

    mickeyw3340 Thread Starter

    Joined:
    Nov 22, 2004
    Messages:
    87
    I have recorded an Excel macro that another person needs to use in the office. To keep from having to re record it on her PC, can it be transferred to another computer? Perhaps there is a utility somewhere to merge one personal.xls file into another, retaning data in the destination file, and only copying the data thet is different from the source file? Thanks in advance.
     
  2. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,271
    Can you not just copy it to Notepad, stick it on a floppy & paste it into a module at the other computer?
     
  3. Rollin_Again

    Rollin_Again

    Joined:
    Sep 4, 2003
    Messages:
    4,732
    You can export the macro.

    In Excel press ALT + F11 to bring up the VB editor. In the project explorer window on the left you should see the module containing your macro code. Just right click the module and select "EXPORT." Export to a floppy or your network drive or even email the module to yourself.

    Follow the same directions on the other computer except select the "IMPORT" options and point to your saved module.

    Rollin
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/411959