J
jbb16x99
Is it possible to copy macros from one computer to another via a disc
(the same way you'd copy files)? Thanks.
(the same way you'd copy files)? Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
DavidP
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
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
P
pfsardella
Here are a couple of links that offer suggestions.
http://www.google.com/groups?hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&safe=off&th=287b17e51628a6f4&rnum=6
http://www.google.com/groups?hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&safe=off&th=38956b9d313622aa&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
http://www.google.com/groups?hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&safe=off&th=287b17e51628a6f4&rnum=6
http://www.google.com/groups?hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&safe=off&th=38956b9d313622aa&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
S
steve
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.
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.
T
Tom Ogilvy
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.
a text file). This can be copied to a floppy disk and imported at another
location.