PC Review


Reply
Thread Tools Rate Thread

Deployment of XL programs in 2003 vs 2007

 
 
XP
Guest
Posts: n/a
 
      25th Apr 2008
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.
 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      25th Apr 2008
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...9157953&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
 
Reply With Quote
 
Jon Peltier
Guest
Posts: n/a
 
      25th Apr 2008
> 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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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...9157953&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



 
Reply With Quote
 
Dave Peterson
Guest
Posts: n/a
 
      26th Apr 2008
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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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...9157953&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
 
Reply With Quote
 
Jon Peltier
Guest
Posts: n/a
 
      26th Apr 2008
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > 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...9157953&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



 
Reply With Quote
 
Dave Peterson
Guest
Posts: n/a
 
      26th Apr 2008
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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> >> news:(E-Mail Removed)...
> >> > 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...9157953&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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:35 AM.