exporting a macro

[Guest]

I have written a macro which is saved in my Personal XLs file. How can I
export this macro to another user by email.

keep it simple please

anthony

 

[davesexcel]

you could just create a workbook with the macro and email the workbook

 

[Paul B]

Anthony, the simple way may be to just copy the code and paste it in an
e-mail. Alt+F8 select your macro, edit copy and paste

Here are some more ways to move and backup macros

You can drag and drop the macros from one workbook to another in the VBA
editor, just open the workbooks and drag and drop. Or if it on another
computer you can export a macro and save it, to do this from your workbook,
right-click the workbook's icon and pick View Code. This icon is to the left
of the "File" menu this will open the VBA editor, in Project Explorer right
click on your workbook name, if you don't see it press CTRL + r to open the
Project Explorer click on the module you want to save and go to file and
export file, then save it to a floppy or what ever you backup to, or e-mail
it, then import it to the new workbook.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Guest]

If you have time could you give more info on how to copy and paste.

I know from where you sit thats probably a stupid q but I can access the
macro with alt f8 but am lost as to copy paste send open save sequence

anthony

 

[Guest]

as macro currently saved in personal do u mean open an excel workbook run the
macro save that workbook under its own name, email it the other user opens
workbook, how do they save macro so next time they open a csv file that
hasn't had the macro run they can selct macros and run it

anthony

 

[Paul B]

Anthony, Alt+F8, select your macro name and edit, when the window opens with
your code press Ctrl+A to select the text in the macro, right click on the
text and pick copy, right click in your e-mail and paste, this will get all
the text of your macro in the e-mail, send it to the person and have them
put it in excel.

To put in this macro, from your workbook right-click the workbook's icon and
pick View Code. This icon is to the left of the "File" menu this will open
the VBA editor, in Project Explorer click on your workbook name, or in there
personal workbook if that is where they want it, if you don't see it press
CTRL + r to open the Project Explorer, if putting in personal workbook and
you do not see it after that they may not have one, if they have never saved
a macro there, if that is the case the easy way to make the personal
workbook is to just record a dummy macro and select save to personal
workbook, stop recording and then go back to project explorer and you should
see it now, put in your code and delete the dummy macro. then go to insert,
module, and paste the code in the window that opens on the right hand side,
press Alt and Q to close this window and go back to your workbook and press
alt and F8, this will bring up a box to pick the Macro from, click on the
Macro name to run it. If you are using excel 2000 or newer you may have to
change the macro security settings to get the macro to run. To change the
security settings go to tools, macro, security, security level and set it to
medium.


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003