Create and Excel Workbook and create Toolbars

[rodger]

Hello all,

I have created an access database that I export a query into an Excel
worksheet and do a little formating and what not. Now I would like to do
two things to the workbook. I want to create a toolbar and then add two
buttons, one to sort the list by last name and another to sort it by first
name. This is going to be used for down time procedure so I want it to be
as easy to use for whom ever is going to be here at the time.

TIA,
Rodger

 

[Daniel Pineault]

You should ask your excel question in an Excel forum.

Secondly, which version of Excel are you coding for as 2007 changed the way
toolbar, should I say Ribbon are created.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[CraigH]

Hi,
I just have a little time and saw Daniel didn't quite read what you were
doing - I am assuming you want to do this from within Access through
automation if not then I didn't understand

Just like you would do with the formating the excel from access you can add
the toolbars - again I won't go into great detail but I don't think this
works in 2007.

It invovles the CommandBars and CommandBarControl.

This links isn't the best for showing how to do it from Access - it is from
the excel side but it will get you in the right direction.

http://www.cpearson.com/excel/menus.htm

As I said this is just qick post to get you started.

 

[Daniel Pineault]

Nope, I do believe I understood the initial request.

For Excel 2003 or Prior:
Take a look at
http://support.microsoft.com/default.aspx/kb/830502
http://www.ozgrid.com/VBA/custom-menus.htm


For Excel 2007:
The fact is that if you wish to manipulate the Excel Ribbon, then you would
be better served to learn about this, including how-to code this, in an Excel
forum. Especially since Access is unique in it's Ribbon manipulation, so
Excel Ribbon manipulation should be asked in an Excel Forum, not Access.

Depending on your needs, I would recommend creating a workbook and doing
your customization to it. Then use your code in Access to pass the data as
required.

As I mentioned, Excel, Word... Ribbon customization is different than that
of Access. To manip. Excel' Ribbon you need to download software that will
generate the require xml file, then add it to the workbook and then finally
you need to add a call back function for each button in your custom ribbon.
Sound complicated but is actually very easy! Take a look at
http://www.rondebruin.nl/ribbon.htm for more information on the subject.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.