Moving Macros from one computer to another Excel 2000

M

Michael J Davis

I have some macros set up on one computer in Personal.xls.

I wish to get them across to another computer containing Excel.

1. I have tried copying Personal.xls but the other Version of Excel
seems to reject it.

2. Is the only way to make a text file of the macro/s, and re create it
on the other m/c?

Or is there a more obvious way?

(I cannot find anything in Help!!)

Thanks

Mike

[The reply-to address is valid for 30 days from this posting]
--
Michael J Davis

Pictures at http://www.flickr.com/photos/watchman/
<><
For this is what the Lord has said to me,
"Go and post a Watchman and let
him report what he sees." Isa 21:6
<><
 
B

Barb Reinhardt

You could try exporting the modules with the code and then import them to the
new workbook.
 
F

FSt1

hi,
I'm guessing that the other pc in an older version. most applications are
backward compatible but none that i know of are "forward compatible".
Try downloading the macros to a disk.
open the vb editor alt+F11. expand your project(file). right click your
macro and from the pop up, click export. follow the wizard. it will down load
as a .BAS file.
In the other pc, reverse the process. open the vb editor alt+F11. expand
your project(file). right click your project and from the pop up, click
import.

Post back if you have problems.
Regards
FSt1
 
D

Dave Peterson

I think I'd try to find out why personal.xls is being rejected. If you're using
both computers (home and work???), it should work fine.

If it's not you at both ends, you'll want to make sure that you're not
overwriting the recipient's personal.xls file. That wouldn't be nice.
I have some macros set up on one computer in Personal.xls.

I wish to get them across to another computer containing Excel.

1. I have tried copying Personal.xls but the other Version of Excel
seems to reject it.

2. Is the only way to make a text file of the macro/s, and re create it
on the other m/c?

Or is there a more obvious way?

(I cannot find anything in Help!!)

Thanks

Mike

[The reply-to address is valid for 30 days from this posting]
--
Michael J Davis

Pictures at http://www.flickr.com/photos/watchman/
<><
For this is what the Lord has said to me,
"Go and post a Watchman and let
him report what he sees." Isa 21:6
<><
Click to expand...
 

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

Getting rid of Flash images in Excel 0
What reassigns the licence of my Office 2000 suite? 2
Excel buttons change macro file name when run on other computers 7
Broken Excel Links - move files to another computer 0
How can i move a macro from one computer to another 3
Changing path of button macro assignment 2
How do I move a toolbar with custom macros over to another computer? 1
How to change the macro called by an add in from older excel? 2

Top