Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Send a macro
Hello What is the best way to send a macro to some one else ? thanks
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Send a macro
Several methods.........don't know what is the best way, all involve some work.
1. Copy the macro code and open Notepad. Paste into Notepad and save then send for "someone else" to copy to a module. 2. Export the module as *.bas file and send that for importing into a workbook. 3. Send the workbook with the macro. Someone else can copy the macro or module to wherever they wish. Gord Dibben MS Excel MVP On Thu, 25 Jan 2007 11:45:01 -0800, Wanna Learn wrote: Hello What is the best way to send a macro to some one else ? thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Send a macro
Hello Gord Thanks..
Sounds like 3 is the easiest way. If I send the workbook I suppose the macro has to be saved in a personal workbook so that they can use with any workbook . Is that correct? "Gord Dibben" wrote: Several methods.........don't know what is the best way, all involve some work. 1. Copy the macro code and open Notepad. Paste into Notepad and save then send for "someone else" to copy to a module. 2. Export the module as *.bas file and send that for importing into a workbook. 3. Send the workbook with the macro. Someone else can copy the macro or module to wherever they wish. Gord Dibben MS Excel MVP On Thu, 25 Jan 2007 11:45:01 -0800, Wanna Learn wrote: Hello What is the best way to send a macro to some one else ? thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Send a macro
Yes, they could copy it to their Personal.xls which makes it available for all
open workbooks. Gord On Fri, 26 Jan 2007 04:03:01 -0800, Wanna Learn wrote: Hello Gord Thanks.. Sounds like 3 is the easiest way. If I send the workbook I suppose the macro has to be saved in a personal workbook so that they can use with any workbook . Is that correct? "Gord Dibben" wrote: Several methods.........don't know what is the best way, all involve some work. 1. Copy the macro code and open Notepad. Paste into Notepad and save then send for "someone else" to copy to a module. 2. Export the module as *.bas file and send that for importing into a workbook. 3. Send the workbook with the macro. Someone else can copy the macro or module to wherever they wish. Gord Dibben MS Excel MVP On Thu, 25 Jan 2007 11:45:01 -0800, Wanna Learn wrote: Hello What is the best way to send a macro to some one else ? thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Send a macro
Thanks Gord
"Gord Dibben" wrote: Yes, they could copy it to their Personal.xls which makes it available for all open workbooks. Gord On Fri, 26 Jan 2007 04:03:01 -0800, Wanna Learn wrote: Hello Gord Thanks.. Sounds like 3 is the easiest way. If I send the workbook I suppose the macro has to be saved in a personal workbook so that they can use with any workbook . Is that correct? "Gord Dibben" wrote: Several methods.........don't know what is the best way, all involve some work. 1. Copy the macro code and open Notepad. Paste into Notepad and save then send for "someone else" to copy to a module. 2. Export the module as *.bas file and send that for importing into a workbook. 3. Send the workbook with the macro. Someone else can copy the macro or module to wherever they wish. Gord Dibben MS Excel MVP On Thu, 25 Jan 2007 11:45:01 -0800, Wanna Learn wrote: Hello What is the best way to send a macro to some one else ? thanks |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Send a macro
I would like to send a workbook to another user, but I do not want them to
have to go through the additional steps of pasting the Macro into their Personal folder. If the Macro will only be used in one workbook, is there a way to attach the Macro to the workbook before sending to another user? I am sure that I am missing something very simple. . . ? "Gord Dibben" wrote: Yes, they could copy it to their Personal.xls which makes it available for all open workbooks. Gord On Fri, 26 Jan 2007 04:03:01 -0800, Wanna Learn wrote: Hello Gord Thanks.. Sounds like 3 is the easiest way. If I send the workbook I suppose the macro has to be saved in a personal workbook so that they can use with any workbook . Is that correct? "Gord Dibben" wrote: Several methods.........don't know what is the best way, all involve some work. 1. Copy the macro code and open Notepad. Paste into Notepad and save then send for "someone else" to copy to a module. 2. Export the module as *.bas file and send that for importing into a workbook. 3. Send the workbook with the macro. Someone else can copy the macro or module to wherever they wish. Gord Dibben MS Excel MVP On Thu, 25 Jan 2007 11:45:01 -0800, Wanna Learn wrote: Hello What is the best way to send a macro to some one else ? thanks |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Send a macro
Sorry, I forgot to mention that I am working with Excel 2007.
"Flintstone" wrote: I would like to send a workbook to another user, but I do not want them to have to go through the additional steps of pasting the Macro into their Personal folder. If the Macro will only be used in one workbook, is there a way to attach the Macro to the workbook before sending to another user? I am sure that I am missing something very simple. . . ? "Gord Dibben" wrote: Yes, they could copy it to their Personal.xls which makes it available for all open workbooks. Gord On Fri, 26 Jan 2007 04:03:01 -0800, Wanna Learn wrote: Hello Gord Thanks.. Sounds like 3 is the easiest way. If I send the workbook I suppose the macro has to be saved in a personal workbook so that they can use with any workbook . Is that correct? "Gord Dibben" wrote: Several methods.........don't know what is the best way, all involve some work. 1. Copy the macro code and open Notepad. Paste into Notepad and save then send for "someone else" to copy to a module. 2. Export the module as *.bas file and send that for importing into a workbook. 3. Send the workbook with the macro. Someone else can copy the macro or module to wherever they wish. Gord Dibben MS Excel MVP On Thu, 25 Jan 2007 11:45:01 -0800, Wanna Learn wrote: Hello What is the best way to send a macro to some one else ? thanks |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Send a macro
Did you miss step 3?
If the macro is to be used only on the workbook you send to other user, simply store the macro in a module in that workbook and save the workbook. Send to other user. Gord On Wed, 4 Nov 2009 11:45:01 -0800, Flintstone wrote: I would like to send a workbook to another user, but I do not want them to have to go through the additional steps of pasting the Macro into their Personal folder. If the Macro will only be used in one workbook, is there a way to attach the Macro to the workbook before sending to another user? I am sure that I am missing something very simple. . . ? "Gord Dibben" wrote: Yes, they could copy it to their Personal.xls which makes it available for all open workbooks. Gord On Fri, 26 Jan 2007 04:03:01 -0800, Wanna Learn wrote: Hello Gord Thanks.. Sounds like 3 is the easiest way. If I send the workbook I suppose the macro has to be saved in a personal workbook so that they can use with any workbook . Is that correct? "Gord Dibben" wrote: Several methods.........don't know what is the best way, all involve some work. 1. Copy the macro code and open Notepad. Paste into Notepad and save then send for "someone else" to copy to a module. 2. Export the module as *.bas file and send that for importing into a workbook. 3. Send the workbook with the macro. Someone else can copy the macro or module to wherever they wish. Gord Dibben MS Excel MVP On Thu, 25 Jan 2007 11:45:01 -0800, Wanna Learn wrote: Hello What is the best way to send a macro to some one else ? thanks |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Send a macro
Thanks Gord. . . Step number 3 is exactly what I am trying to do. I want to
store the macro in the workbook, but I do not know how? I will continue my search. . . "Gord Dibben" wrote: Did you miss step 3? If the macro is to be used only on the workbook you send to other user, simply store the macro in a module in that workbook and save the workbook. Send to other user. Gord On Wed, 4 Nov 2009 11:45:01 -0800, Flintstone wrote: I would like to send a workbook to another user, but I do not want them to have to go through the additional steps of pasting the Macro into their Personal folder. If the Macro will only be used in one workbook, is there a way to attach the Macro to the workbook before sending to another user? I am sure that I am missing something very simple. . . ? "Gord Dibben" wrote: Yes, they could copy it to their Personal.xls which makes it available for all open workbooks. Gord On Fri, 26 Jan 2007 04:03:01 -0800, Wanna Learn wrote: Hello Gord Thanks.. Sounds like 3 is the easiest way. If I send the workbook I suppose the macro has to be saved in a personal workbook so that they can use with any workbook . Is that correct? "Gord Dibben" wrote: Several methods.........don't know what is the best way, all involve some work. 1. Copy the macro code and open Notepad. Paste into Notepad and save then send for "someone else" to copy to a module. 2. Export the module as *.bas file and send that for importing into a workbook. 3. Send the workbook with the macro. Someone else can copy the macro or module to wherever they wish. Gord Dibben MS Excel MVP On Thu, 25 Jan 2007 11:45:01 -0800, Wanna Learn wrote: Hello What is the best way to send a macro to some one else ? thanks . |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Send a macro
Thanks again for your help. I was able to find the link below which provided
information on how to move a macro from one workbook to another (step #3). http://excel.tips.net/Pages/T002575_...orkbook.h tml "Flintstone" wrote: Thanks Gord. . . Step number 3 is exactly what I am trying to do. I want to store the macro in the workbook, but I do not know how? I will continue my search. . . "Gord Dibben" wrote: Did you miss step 3? If the macro is to be used only on the workbook you send to other user, simply store the macro in a module in that workbook and save the workbook. Send to other user. Gord On Wed, 4 Nov 2009 11:45:01 -0800, Flintstone wrote: I would like to send a workbook to another user, but I do not want them to have to go through the additional steps of pasting the Macro into their Personal folder. If the Macro will only be used in one workbook, is there a way to attach the Macro to the workbook before sending to another user? I am sure that I am missing something very simple. . . ? "Gord Dibben" wrote: Yes, they could copy it to their Personal.xls which makes it available for all open workbooks. Gord On Fri, 26 Jan 2007 04:03:01 -0800, Wanna Learn wrote: Hello Gord Thanks.. Sounds like 3 is the easiest way. If I send the workbook I suppose the macro has to be saved in a personal workbook so that they can use with any workbook . Is that correct? "Gord Dibben" wrote: Several methods.........don't know what is the best way, all involve some work. 1. Copy the macro code and open Notepad. Paste into Notepad and save then send for "someone else" to copy to a module. 2. Export the module as *.bas file and send that for importing into a workbook. 3. Send the workbook with the macro. Someone else can copy the macro or module to wherever they wish. Gord Dibben MS Excel MVP On Thu, 25 Jan 2007 11:45:01 -0800, Wanna Learn wrote: Hello What is the best way to send a macro to some one else ? thanks . |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Send a macro
Good to hear you're fixed up.
I did not realize you would not know about copy/pasting a macro from one book to another or I would have provided some instructions. Gord On Thu, 5 Nov 2009 08:56:02 -0800, Flintstone wrote: Thanks again for your help. I was able to find the link below which provided information on how to move a macro from one workbook to another (step #3). http://excel.tips.net/Pages/T002575_...orkbook.h tml "Flintstone" wrote: Thanks Gord. . . Step number 3 is exactly what I am trying to do. I want to store the macro in the workbook, but I do not know how? I will continue my search. . . "Gord Dibben" wrote: Did you miss step 3? If the macro is to be used only on the workbook you send to other user, simply store the macro in a module in that workbook and save the workbook. Send to other user. Gord On Wed, 4 Nov 2009 11:45:01 -0800, Flintstone wrote: I would like to send a workbook to another user, but I do not want them to have to go through the additional steps of pasting the Macro into their Personal folder. If the Macro will only be used in one workbook, is there a way to attach the Macro to the workbook before sending to another user? I am sure that I am missing something very simple. . . ? "Gord Dibben" wrote: Yes, they could copy it to their Personal.xls which makes it available for all open workbooks. Gord On Fri, 26 Jan 2007 04:03:01 -0800, Wanna Learn wrote: Hello Gord Thanks.. Sounds like 3 is the easiest way. If I send the workbook I suppose the macro has to be saved in a personal workbook so that they can use with any workbook . Is that correct? "Gord Dibben" wrote: Several methods.........don't know what is the best way, all involve some work. 1. Copy the macro code and open Notepad. Paste into Notepad and save then send for "someone else" to copy to a module. 2. Export the module as *.bas file and send that for importing into a workbook. 3. Send the workbook with the macro. Someone else can copy the macro or module to wherever they wish. Gord Dibben MS Excel MVP On Thu, 25 Jan 2007 11:45:01 -0800, Wanna Learn wrote: Hello What is the best way to send a macro to some one else ? thanks . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I email amacro? | Excel Worksheet Functions | |||
error when running cut & paste macro | Excel Worksheet Functions | |||
using macro to send e-mail | Excel Discussion (Misc queries) | |||
How do I write a macro for a button to send user to a custom view? | Excel Discussion (Misc queries) | |||
How to Create an Excel Macro to send a meeting request. | Excel Discussion (Misc queries) |