Moving Macros from one computer to another Excel 2000

[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
<><

 

[Guest]

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

 

[Guest]

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

 

[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
<><