If you export your code from the VBE, it creates a .BAS file (which is just
a text file). This can be copied to a floppy disk and imported at another
location.

--
Regards,
Tom Ogilvy

"DavidP" wrote in message
...
No problem at all. The easy way would be to copy the whole excel file
and then cut and paste between files on the new machine. If this is
impractical then why not paste the code into notepador any other word
processor and transfer it as a text file. If you go this riout you
may have a problem with word wrap splitting formulas on to different
lines



On 23 Oct 2003 07:49:11 -0700, (jbb16x99) wrote:

Is it possible to copy macros from one computer to another via a disc
(the same way you'd copy files)? Thanks.