Moving Macros from one computer to another Excel 2000
 

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

Moving Macros from one computer to another Excel 2000
 

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

"Michael J Davis" wrote:


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

Moving Macros from one computer to another Excel 2000
 

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

"Michael J Davis" wrote:


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

Moving Macros from one computer to another Excel 2000
 

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.

Michael J Davis wrote:

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

--

Dave Peterson