Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
exporting a macro
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
exporting a macro
you could just create a workbook with the macro and email the workbook -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=516764 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
exporting a macro
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 "Anthony" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
exporting a macro
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 "Paul B" wrote: 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 "Anthony" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
exporting a macro
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 "davesexcel" wrote: you could just create a workbook with the macro and email the workbook -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=516764 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
exporting a macro
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 "Anthony" wrote in message ... 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 "Paul B" wrote: 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 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 "Anthony" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
exporting a macro | Excel Discussion (Misc queries) | |||
Exporting a Macro | Excel Discussion (Misc queries) | |||
Exporting the same Excel macro to 60 workbooks | Excel Programming | |||
Need Excel macro for exporting data to Access | Excel Programming | |||
Excel Macro exporting to MS-Project 2002 | Excel Programming |