export macros

[Ruben Mikkelsen]

IS it possible to take the macros recorded
and copy them to another mashine ? That way I wont have to
record them over and over again for each mashine.

ruben

 

[Tom Ogilvy]

Yes. It should work.

 

[Tom Ogilvy]

As an example, people are constantly posting code in this newsgroup. Others
are copying that code and pasting into their copy of excel and using it.

 

[Bob Phillips]

Ruben,

All macros are recorded into a workbook, so just copy the workbook over.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[William]

Hi Ruben

Can you not copy the Excel file containing all the macros on to
another machine?

--
XL2002
Regards

William

(e-mail address removed)

|
| IS it possible to take the macros recorded
| and copy them to another mashine ? That way I wont have to
| record them over and over again for each mashine.
|
| ruben
|
|

 

[Ruben Mikkelsen]

Thanks for all your replys, however I'm still a bit in the dark.

The file that the macros are run on changes every week. So I've
made the macros "permanent" in excel. When you close the file after you've
first recorded the macro you are given the option to make the macros
available to excel or store them in the .xls file. I chose the first.Are the
macros stored on the mashine in a file that I can take with me to each of
the other mashines, or will I have to either copy the code or store the
macro in the .xls file.

Hope someone will understand what I'm getting at

Regards
Ruben

 

[Tom Ogilvy]

in the xlstart directory below the directory that contains Excel.exe, you
will have a personal.xls workbook. This is where the macro is stored. This
workbook is loaded each time excel is started.

What I suggest you do is go into the VBE Alt+F11 and in the project
explored, look for personal.xls. Under modules click on each module until
you find you macro. Copy this macro and paste it in notepad, then save this
as a text file. Now you can take this text file around and copy the macro
into each computers personal.xls (they won't have one unless the user has
recorded a macro and selected to store it in personal.xls). If the person
doesn't have one, you can record a dummy macro (just select a cell, then
stop recording). The go into the vbe and paste in your macro.

I wouldn't suggest carrying around your personal.xls as it would conflict
with personal.xls files created by others. However, if they don't have a
personal.xls, then you could copy your to there computers.

 

[Ken Wright]

Ruben, when you record a macro you get the option of where to store it in
the dialog box. The options will be to either store it in 'This workbook'
referring to the workbook you are currently in, or to store it in your
'personal macro workbook' which is usually invisible to you (Assuming you
have one) but opens each time you launch Excel.

If a macro is stored in a workbook then when that workbook is open the macro
is available to be run from that or any other open workbook. If it is in
your personal.xls then it will be available to you no matter what workbook
you are working with.

The macros are stored in what is called a module in either of those two
files and is easily transferrable. I have a lot of macros that I use
regularly that are not specific to any particular workbook, so I keep them
in my personal.xls. I also keep a copy of that personal.xls on a memory
stick that I carry round with me and can then stick it on any machine I work
on, and as a result I can then immediately access all the macros that I am
used to working with. If the macros are specific to a workbook then they
should stay in that workbook and you can run them no matter what machine you
open the workbook with.

Give us an idea of what the macros do and we can suggest the optimal route
to take.

 

[Ruben Mikkelsen]

I found the file containing the macros "global.xls". I copied it to
the xlstart folder of another mashine and found the source code by hitting
alt+f11. Now I am able to assign buttons to the different macros. Perfect.
Thanks a million guys

ruben

 

[Steve Rose]

I suggest you should use the export module wizard to export the whole module
into the new workbook.