View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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