copying macros
 

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

copying macros
 

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.

copying macros
 

Here are a couple of links that offer suggestions.

http://www.google.com/groups?hl=en&l...628a6f4&rnum=6
http://www.google.com/groups?hl=en&l...3622aa&rnum=16

Three of the most common suggestions :

1. If a whole module, export the module and import into the other
file.

2. If both files are open in excel, then go to the VBE and drag the
module from one file into the other with the mouse.

3. Copy your code to newly created workbook. Save the workbook as an
Add-in(*.XLA) and copy the add-in to the other machine.

Obviously, number 2 is not relevant to your situation.

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------
Is it possible to copy macros from one computer to another via a disc
(the same way you'd copy files)? Thanks.

copying macros
 

In the VB Editor you can select individual modules (one at a time) and
Use the File Export and File Import to do this.

An easier way is to put the macros in a single workbook and same the
workbook to a disc.

Modules (macros) can be transfered from one project (workbook) to
another using drag and drop in the VB Editor window.

Just keep in mind that for the most part - the macros are an integral part
of 'a' workbook, any workbook.

If you haven't already learned about your Personal.xls you might want to
look into it. This is a great place to store 'universal' macros. Just know
that this workbook is stored in your XLStart folder and opens automatically
everytime Excel starts up. You can put other workbooks in this folder and
they too will open each time Excel starts up.

--
sb
"jbb16x99" wrote in message
om...
Is it possible to copy macros from one computer to another via a disc
(the same way you'd copy files)? Thanks.

copying macros
 

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.