Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Macro Dist.
Good Morning Everyone!
I have a quick question regarding the distribution of macros. In the office where I am located we have employees who aren't exactly as computer literate as we'd like them to be. Therefore, giving them instructions on how to manually input the provided code into the VBA editor would be tedious and time consuming. I'm wondering if there is a way to neatly package these macros and deliver them across a network of employees, such as a .exe file of some sort. I know that you can create buttons to execute the macro, so I'm thinking that if I create an Excel file with the buttons and some instructions it'll work out, but will the macro code be sent along with the Excel file? Thanks for the help!! -Joseph, IBT Employee |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Macro Dist.
I would suggest creating an Add-in with the macros.
When the Add-in is loaded, have it create a top menu item with all your macros listed for easy reference by your not quite literate fellow employees. John Walkenbach has some great books that reference Add-ins. 'Power Programming with VBA': For 2003, see... http://j-walk.com/ss/books/xlbook25.htm For 2007, see... http://j-walk.com/ss/books/index.htm John's general site is... http://www.j-walk.com/ -- Hope this helps. If this post was helpfull, please remember to click on the ''''YES'''' button at the bottom of the screen. Thanks, Gary Brown "IBT Employee" wrote: Good Morning Everyone! I have a quick question regarding the distribution of macros. In the office where I am located we have employees who aren't exactly as computer literate as we'd like them to be. Therefore, giving them instructions on how to manually input the provided code into the VBA editor would be tedious and time consuming. I'm wondering if there is a way to neatly package these macros and deliver them across a network of employees, such as a .exe file of some sort. I know that you can create buttons to execute the macro, so I'm thinking that if I create an Excel file with the buttons and some instructions it'll work out, but will the macro code be sent along with the Excel file? Thanks for the help!! -Joseph, IBT Employee |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Macro Dist.
Hi Joseph,
A comprehensive article about distributing macros in a reliable way: http://www.jkp-ads.com/Articles/DistributeMacro00.htm -- Kind regards, Niek Otten Microsoft MVP - Excel "IBT Employee" wrote in message ... | Good Morning Everyone! | | I have a quick question regarding the distribution of macros. | | In the office where I am located we have employees who aren't exactly as | computer literate as we'd like them to be. Therefore, giving them | instructions on how to manually input the provided code into the VBA editor | would be tedious and time consuming. | | I'm wondering if there is a way to neatly package these macros and deliver | them across a network of employees, such as a .exe file of some sort. I know | that you can create buttons to execute the macro, so I'm thinking that if I | create an Excel file with the buttons and some instructions it'll work out, | but will the macro code be sent along with the Excel file? | | Thanks for the help!! | | -Joseph, IBT Employee |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Macro Dist.
Not enough information to be very specific, but generally speaking for
shared code an addin is the way to go. How you distribute and maintain it depends on your needs. OTOH if this is a one-time project you may be able to get away with emailing the workbook. Macros are stored wherever you have stored them. If you record a macro you can store them in the Personal Macro Workbook (which I never do), or ThisWorkbook or a new workbook. Toolbars are better created programmatically rather than "attached" to a workbook. -- Tim Zych www.higherdata.com Compare data in Excel and find differences with Workbook Compare A free, powerful, flexible Excel utility "IBT Employee" wrote in message ... Good Morning Everyone! I have a quick question regarding the distribution of macros. In the office where I am located we have employees who aren't exactly as computer literate as we'd like them to be. Therefore, giving them instructions on how to manually input the provided code into the VBA editor would be tedious and time consuming. I'm wondering if there is a way to neatly package these macros and deliver them across a network of employees, such as a .exe file of some sort. I know that you can create buttons to execute the macro, so I'm thinking that if I create an Excel file with the buttons and some instructions it'll work out, but will the macro code be sent along with the Excel file? Thanks for the help!! -Joseph, IBT Employee |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Macro Dist.
Thanks for all the replies! The guides have been very helpful.
"Tim Zych" wrote: Not enough information to be very specific, but generally speaking for shared code an addin is the way to go. How you distribute and maintain it depends on your needs. OTOH if this is a one-time project you may be able to get away with emailing the workbook. Macros are stored wherever you have stored them. If you record a macro you can store them in the Personal Macro Workbook (which I never do), or ThisWorkbook or a new workbook. Toolbars are better created programmatically rather than "attached" to a workbook. -- Tim Zych www.higherdata.com Compare data in Excel and find differences with Workbook Compare A free, powerful, flexible Excel utility "IBT Employee" wrote in message ... Good Morning Everyone! I have a quick question regarding the distribution of macros. In the office where I am located we have employees who aren't exactly as computer literate as we'd like them to be. Therefore, giving them instructions on how to manually input the provided code into the VBA editor would be tedious and time consuming. I'm wondering if there is a way to neatly package these macros and deliver them across a network of employees, such as a .exe file of some sort. I know that you can create buttons to execute the macro, so I'm thinking that if I create an Excel file with the buttons and some instructions it'll work out, but will the macro code be sent along with the Excel file? Thanks for the help!! -Joseph, IBT Employee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Include email dist. list into a Excel macro - how? | Excel Worksheet Functions | |||
How can I shade area under a norm dist graph? | Charts and Charting in Excel | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |