Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deployment of XL programs in 2003 vs 2007
In Office 2003, I typically created self-installing toolbars in hidden
workbooks which I then emailed to users. When users opened the program file, the toolbar would be built, but the file would run hidden. At any future time that the user needed those programs, they would just click any of the toolbar buttons and the file would open quietly, run hidden, and the programs were immediately available. It all worked very nicely and they didn't need to go searching for programs. They could also turn the toolbars on/off if desired without de-installing. I'm still learning about the ribbon and I've done some customizations of it. But, I'm still trying to figure out how I can duplicate this same sort of deployment in 2007 (or improved deployment). I guess I could still hide the file containing the custom ribbon and the users would just have to find and open the program file to get to the custom tools? Can someone please give me some ideas on how to approach this? I do not have VSTO or any other development tools. I only have Windows XP, Office 2007 and the apps that come with it. Ideas? Where should I start looking? Thanks much in advance for your assistance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deployment of XL programs in 2003 vs 2007
Your toolbars are still created--but they only show up in the Addins tab.
I'm gonna start with Ron de Bruin's site when I get enough courage. If you want to learn about modifying the ribbon, you can start at Ron de Bruin's site: http://www.rondebruin.nl/ribbon.htm http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an addin) or http://www.rondebruin.nl/2007addin.htm And maybe read this: http://www.amazon.com/RibbonX-Custom...57953&sr= 8-1 or http://snipurl.com/25ty2 [www_amazon_com] By Robert Martin, Ken Puls, and Teresa Henniq. XP wrote: In Office 2003, I typically created self-installing toolbars in hidden workbooks which I then emailed to users. When users opened the program file, the toolbar would be built, but the file would run hidden. At any future time that the user needed those programs, they would just click any of the toolbar buttons and the file would open quietly, run hidden, and the programs were immediately available. It all worked very nicely and they didn't need to go searching for programs. They could also turn the toolbars on/off if desired without de-installing. I'm still learning about the ribbon and I've done some customizations of it. But, I'm still trying to figure out how I can duplicate this same sort of deployment in 2007 (or improved deployment). I guess I could still hide the file containing the custom ribbon and the users would just have to find and open the program file to get to the custom tools? Can someone please give me some ideas on how to approach this? I do not have VSTO or any other development tools. I only have Windows XP, Office 2007 and the apps that come with it. Ideas? Where should I start looking? Thanks much in advance for your assistance. -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deployment of XL programs in 2003 vs 2007
I'm gonna start with Ron de Bruin's site when I get enough courage.
It's actually easier than using VBA to build menus and toolbars, but it's separate from VBA and difficult to adjust on the fly. Ron's site is a good starting place, and so is the book you cite. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Dave Peterson" wrote in message ... Your toolbars are still created--but they only show up in the Addins tab. I'm gonna start with Ron de Bruin's site when I get enough courage. If you want to learn about modifying the ribbon, you can start at Ron de Bruin's site: http://www.rondebruin.nl/ribbon.htm http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an addin) or http://www.rondebruin.nl/2007addin.htm And maybe read this: http://www.amazon.com/RibbonX-Custom...57953&sr= 8-1 or http://snipurl.com/25ty2 [www_amazon_com] By Robert Martin, Ken Puls, and Teresa Henniq. XP wrote: In Office 2003, I typically created self-installing toolbars in hidden workbooks which I then emailed to users. When users opened the program file, the toolbar would be built, but the file would run hidden. At any future time that the user needed those programs, they would just click any of the toolbar buttons and the file would open quietly, run hidden, and the programs were immediately available. It all worked very nicely and they didn't need to go searching for programs. They could also turn the toolbars on/off if desired without de-installing. I'm still learning about the ribbon and I've done some customizations of it. But, I'm still trying to figure out how I can duplicate this same sort of deployment in 2007 (or improved deployment). I guess I could still hide the file containing the custom ribbon and the users would just have to find and open the program file to get to the custom tools? Can someone please give me some ideas on how to approach this? I do not have VSTO or any other development tools. I only have Windows XP, Office 2007 and the apps that come with it. Ideas? Where should I start looking? Thanks much in advance for your assistance. -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deployment of XL programs in 2003 vs 2007
And the ribbon sure looks prettier, too.
Jon Peltier wrote: I'm gonna start with Ron de Bruin's site when I get enough courage. It's actually easier than using VBA to build menus and toolbars, but it's separate from VBA and difficult to adjust on the fly. Ron's site is a good starting place, and so is the book you cite. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Dave Peterson" wrote in message ... Your toolbars are still created--but they only show up in the Addins tab. I'm gonna start with Ron de Bruin's site when I get enough courage. If you want to learn about modifying the ribbon, you can start at Ron de Bruin's site: http://www.rondebruin.nl/ribbon.htm http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an addin) or http://www.rondebruin.nl/2007addin.htm And maybe read this: http://www.amazon.com/RibbonX-Custom...57953&sr= 8-1 or http://snipurl.com/25ty2 [www_amazon_com] By Robert Martin, Ken Puls, and Teresa Henniq. XP wrote: In Office 2003, I typically created self-installing toolbars in hidden workbooks which I then emailed to users. When users opened the program file, the toolbar would be built, but the file would run hidden. At any future time that the user needed those programs, they would just click any of the toolbar buttons and the file would open quietly, run hidden, and the programs were immediately available. It all worked very nicely and they didn't need to go searching for programs. They could also turn the toolbars on/off if desired without de-installing. I'm still learning about the ribbon and I've done some customizations of it. But, I'm still trying to figure out how I can duplicate this same sort of deployment in 2007 (or improved deployment). I guess I could still hide the file containing the custom ribbon and the users would just have to find and open the program file to get to the custom tools? Can someone please give me some ideas on how to approach this? I do not have VSTO or any other development tools. I only have Windows XP, Office 2007 and the apps that come with it. Ideas? Where should I start looking? Thanks much in advance for your assistance. -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deployment of XL programs in 2003 vs 2007
That's because it's not cluttered with all those customized toolbars filled
with buttons the users find helpful. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Dave Peterson" wrote in message ... And the ribbon sure looks prettier, too. Jon Peltier wrote: I'm gonna start with Ron de Bruin's site when I get enough courage. It's actually easier than using VBA to build menus and toolbars, but it's separate from VBA and difficult to adjust on the fly. Ron's site is a good starting place, and so is the book you cite. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Dave Peterson" wrote in message ... Your toolbars are still created--but they only show up in the Addins tab. I'm gonna start with Ron de Bruin's site when I get enough courage. If you want to learn about modifying the ribbon, you can start at Ron de Bruin's site: http://www.rondebruin.nl/ribbon.htm http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an addin) or http://www.rondebruin.nl/2007addin.htm And maybe read this: http://www.amazon.com/RibbonX-Custom...57953&sr= 8-1 or http://snipurl.com/25ty2 [www_amazon_com] By Robert Martin, Ken Puls, and Teresa Henniq. XP wrote: In Office 2003, I typically created self-installing toolbars in hidden workbooks which I then emailed to users. When users opened the program file, the toolbar would be built, but the file would run hidden. At any future time that the user needed those programs, they would just click any of the toolbar buttons and the file would open quietly, run hidden, and the programs were immediately available. It all worked very nicely and they didn't need to go searching for programs. They could also turn the toolbars on/off if desired without de-installing. I'm still learning about the ribbon and I've done some customizations of it. But, I'm still trying to figure out how I can duplicate this same sort of deployment in 2007 (or improved deployment). I guess I could still hide the file containing the custom ribbon and the users would just have to find and open the program file to get to the custom tools? Can someone please give me some ideas on how to approach this? I do not have VSTO or any other development tools. I only have Windows XP, Office 2007 and the apps that come with it. Ideas? Where should I start looking? Thanks much in advance for your assistance. -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deployment of XL programs in 2003 vs 2007
From Saturday Night Live:
It's not how you feel, it's how you look. And xl2007 looks mahvalous. Jon Peltier wrote: That's because it's not cluttered with all those customized toolbars filled with buttons the users find helpful. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Dave Peterson" wrote in message ... And the ribbon sure looks prettier, too. Jon Peltier wrote: I'm gonna start with Ron de Bruin's site when I get enough courage. It's actually easier than using VBA to build menus and toolbars, but it's separate from VBA and difficult to adjust on the fly. Ron's site is a good starting place, and so is the book you cite. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Dave Peterson" wrote in message ... Your toolbars are still created--but they only show up in the Addins tab. I'm gonna start with Ron de Bruin's site when I get enough courage. If you want to learn about modifying the ribbon, you can start at Ron de Bruin's site: http://www.rondebruin.nl/ribbon.htm http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an addin) or http://www.rondebruin.nl/2007addin.htm And maybe read this: http://www.amazon.com/RibbonX-Custom...57953&sr= 8-1 or http://snipurl.com/25ty2 [www_amazon_com] By Robert Martin, Ken Puls, and Teresa Henniq. XP wrote: In Office 2003, I typically created self-installing toolbars in hidden workbooks which I then emailed to users. When users opened the program file, the toolbar would be built, but the file would run hidden. At any future time that the user needed those programs, they would just click any of the toolbar buttons and the file would open quietly, run hidden, and the programs were immediately available. It all worked very nicely and they didn't need to go searching for programs. They could also turn the toolbars on/off if desired without de-installing. I'm still learning about the ribbon and I've done some customizations of it. But, I'm still trying to figure out how I can duplicate this same sort of deployment in 2007 (or improved deployment). I guess I could still hide the file containing the custom ribbon and the users would just have to find and open the program file to get to the custom tools? Can someone please give me some ideas on how to approach this? I do not have VSTO or any other development tools. I only have Windows XP, Office 2007 and the apps that come with it. Ideas? Where should I start looking? Thanks much in advance for your assistance. -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wedge programs - linking rs232 to excel 2003 | Excel Discussion (Misc queries) | |||
deployment qn, Excel 2007 customization | Excel Discussion (Misc queries) | |||
Copying Excel 2007 data to external programs | Excel Discussion (Misc queries) | |||
Using OWC VBA programs in excel 2000/2002/2003 | Excel Programming | |||
App using OWC 2003 Deployment - How to ? | Excel Programming |