Deployment of XL programs in 2003 vs 2007

X

XP

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.
 
D

Dave Peterson

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-Custo...bs_sr_1?ie=UTF8&s=books&qid=1209157953&sr=8-1

or
http://snipurl.com/25ty2 [www_amazon_com]

By Robert Martin, Ken Puls, and Teresa Henniq.
 
J

Jon Peltier

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 said:
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-Custo...bs_sr_1?ie=UTF8&s=books&qid=1209157953&sr=8-1

or
http://snipurl.com/25ty2 [www_amazon_com]

By Robert Martin, Ken Puls, and Teresa Henniq.


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.
 
D

Dave Peterson

And the ribbon sure looks prettier, too.

Jon said:
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 said:
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-Custo...bs_sr_1?ie=UTF8&s=books&qid=1209157953&sr=8-1

or
http://snipurl.com/25ty2 [www_amazon_com]

By Robert Martin, Ken Puls, and Teresa Henniq.


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.
 
J

Jon Peltier

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 said:
And the ribbon sure looks prettier, too.

Jon said:
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 said:
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-Custo...bs_sr_1?ie=UTF8&s=books&qid=1209157953&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.
 
D

Dave Peterson

From Saturday Night Live:
It's not how you feel, it's how you look. And xl2007 looks mahvalous.

Jon said:
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 said:
And the ribbon sure looks prettier, too.

Jon said:
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
_______

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-Custo...bs_sr_1?ie=UTF8&s=books&qid=1209157953&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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top