Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating and Sharing a .xla VBA Macro
I wrote a macro that will recognize eight different filenames and run
the appropriate section of code when one of those eight (Excel) files are open. My goal is to make this macro available to a few other users by creating a .xla file and saving it on a folder on a network drive. I've created this add-in and placed it in the desired folder on the network drive and I've looked over this Google group and other, similar groups but still can't put all the pieces together to make this available to others. I initially thought this would (should?) be easy to do but apparently it's not. Any/all suggestions would be appreciated. Thanks, Sheldon Potolsky |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating and Sharing a .xla VBA Macro
Why you want to store this code in an add in instead of a Workbook?
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating and Sharing a .xla VBA Macro
Here's hoow to make the add-in available to other users. Have them go to
Tools menu Add-Ins, click Browse, then find the add-in on the network. Once selected, it will be checked in the list, and when you click okay it will be installed. Any toolbars or other UI elements that it builds will be available so the user can actually use the code. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Sheldon Potolsky" wrote in message ... I wrote a macro that will recognize eight different filenames and run the appropriate section of code when one of those eight (Excel) files are open. My goal is to make this macro available to a few other users by creating a .xla file and saving it on a folder on a network drive. I've created this add-in and placed it in the desired folder on the network drive and I've looked over this Google group and other, similar groups but still can't put all the pieces together to make this available to others. I initially thought this would (should?) be easy to do but apparently it's not. Any/all suggestions would be appreciated. Thanks, Sheldon Potolsky |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating and Sharing a .xla VBA Macro
One problem. After creating the add-in, I tried to create a button
and assign a macro (Macros/Custom Button/Modify Selection/Assign Macro but "Macros In" had no visibility to where I placed my .xla (add-in). It would only allow me to look in All Open Workbooks, This Workbook or PERSONAL.XLS. I thought I'd try to manually create a button and see if it worked but can't figure out how to make it point to where I'd like it. Thanks, Sheldon On Mar 17, 10:20*pm, "Jon Peltier" wrote: Here's hoow to make the add-in available to other users. Have them go to Tools menu Add-Ins, click Browse, then find the add-in on the network. Once selected, it will be checked in the list, and when you click okay it will be installed. Any toolbars or other UI elements that it builds will be available so the user can actually use the code. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ "Sheldon Potolsky" wrote in message ... I wrote a macro that will recognize eight different filenames and run the appropriate section of code when one of those eight (Excel) files are open. *My goal is to make this macro available to a few other users by creating a .xla file and saving it on a folder on a network drive. *I've created this add-in and placed it in the desired folder on the network drive and I've looked over this Google group and other, similar groups but still can't put all the pieces together to make this available to others. *I initially thought this would (should?) be easy to do but apparently it's not. *Any/all suggestions would be appreciated. Thanks, Sheldon Potolsky- Hide quoted text - - Hide quoted text - |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating and Sharing a .xla VBA Macro
I'm not sure what the best way to accomplish this but my goal is still
to make an Excel VBA module that I wrote and is in my PERSONAL.XLS, available to a few other users. I'm open to the easiest/best way to do this. Thanks, Sheldon On Mar 17, 9:50*pm, " wrote: Why you want to store this code in an add in instead of a Workbook? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating and Sharing a .xla VBA Macro
Don't try to build the toolbar manually. It will not work properly.
Here are some links that show how to build a toolbar or menu automatically when a workbook is opened: http://contextures.com/xlToolbar02.html http://www.j-walk.com/ss/excel/tips/tip53.htm - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Sheldon Potolsky" wrote in message ... One problem. After creating the add-in, I tried to create a button and assign a macro (Macros/Custom Button/Modify Selection/Assign Macro but "Macros In" had no visibility to where I placed my .xla (add-in). It would only allow me to look in All Open Workbooks, This Workbook or PERSONAL.XLS. I thought I'd try to manually create a button and see if it worked but can't figure out how to make it point to where I'd like it. Thanks, Sheldon On Mar 17, 10:20 pm, "Jon Peltier" wrote: Here's hoow to make the add-in available to other users. Have them go to Tools menu Add-Ins, click Browse, then find the add-in on the network. Once selected, it will be checked in the list, and when you click okay it will be installed. Any toolbars or other UI elements that it builds will be available so the user can actually use the code. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ "Sheldon Potolsky" wrote in message ... I wrote a macro that will recognize eight different filenames and run the appropriate section of code when one of those eight (Excel) files are open. My goal is to make this macro available to a few other users by creating a .xla file and saving it on a folder on a network drive. I've created this add-in and placed it in the desired folder on the network drive and I've looked over this Google group and other, similar groups but still can't put all the pieces together to make this available to others. I initially thought this would (should?) be easy to do but apparently it's not. Any/all suggestions would be appreciated. Thanks, Sheldon Potolsky- Hide quoted text - - Hide quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sharing or Emailing Macro | Excel Discussion (Misc queries) | |||
sharing a macro | Excel Worksheet Functions | |||
Macro & Tool Bar Sharing | Excel Programming | |||
Macro Sharing | Excel Programming |