Auto Text dilema in 2007

[Joe]

I'm trying to develop additonal features for a custom ribbon in office 2007.

I need to create a toolbar.....errr.....a custom ribbon with about 10-15
groups with buttons. When the button is pressed i need it to insert a
AutoTextList and change the style of the list to simply present a short list
of autotext choices. The AutoTextList will simply display "Right Click to
Choose Code" When the user's click on the list it will display all the
autotext associated with that style.

i want to be able to pull the autotextlist from a database table based on
the "style" this will allow me to update the table since it will change over
time.

any suggestions on the best way to handle this? I've done the autotextlist
many times, but, not pulling it from a DB.

thanks

Joe

 

[Patrick Schmid [MVP]]

Are you asking about how to do the Ribbon UI part of it, or the AutoText
part? I'll gladly help you with the Ribbon UI part, but I can't help
with the other one.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 Beta 2 Technical Refresh (B2TR):
http://pschmid.net/blog/2006/09/18/43
***
Customize Office 2007: http://pschmid.net/office2007/customize
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

 

[Joe]

Hi Patrick,

it really is two parts. One is the ribbon and the other is pulling the
autotext from the DB or file.

whatever you can help with the ribbon would be great.

thanks
Joe

Are you asking about how to do the Ribbon UI part of it, or the AutoText
part? I'll gladly help you with the Ribbon UI part, but I can't help
with the other one.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 Beta 2 Technical Refresh (B2TR):
http://pschmid.net/blog/2006/09/18/43
***
Customize Office 2007: http://pschmid.net/office2007/customize
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

I'm trying to develop additonal features for a custom ribbon in office 2007.

I need to create a toolbar.....errr.....a custom ribbon with about 10-15
groups with buttons. When the button is pressed i need it to insert a
AutoTextList and change the style of the list to simply present a short list
of autotext choices. The AutoTextList will simply display "Right Click to
Choose Code" When the user's click on the list it will display all the
autotext associated with that style.

i want to be able to pull the autotextlist from a database table based on
the "style" this will allow me to update the table since it will change over
time.

any suggestions on the best way to handle this? I've done the autotextlist
many times, but, not pulling it from a DB.

thanks

Joe

 

[Patrick Schmid [MVP]]

Let me send you off to my blog first. Just go on it and read the RibbonX
posts with the oldest one first. That should cover all the things you
need to know to do this. Just one warning, the examples on my site don't
work with B2TR. I still need to update all the idMso's as MS changed all
of them with B2TR. I am currently working on that and on better
organizing the material as well.
If you have specific questions after you read my blog or need help with
getting the code straight, just post back and I'll reply.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 Beta 2 Technical Refresh (B2TR):
http://pschmid.net/blog/2006/09/18/43
***
Customize Office 2007: http://pschmid.net/office2007/customize
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

Hi Patrick,

it really is two parts. One is the ribbon and the other is pulling the
autotext from the DB or file.

whatever you can help with the ribbon would be great.

thanks
Joe

Are you asking about how to do the Ribbon UI part of it, or the AutoText
part? I'll gladly help you with the Ribbon UI part, but I can't help
with the other one.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 Beta 2 Technical Refresh (B2TR):
http://pschmid.net/blog/2006/09/18/43
***
Customize Office 2007: http://pschmid.net/office2007/customize
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

I'm trying to develop additonal features for a custom ribbon in office 2007.

I need to create a toolbar.....errr.....a custom ribbon with about 10-15
groups with buttons. When the button is pressed i need it to insert a
AutoTextList and change the style of the list to simply present a short list
of autotext choices. The AutoTextList will simply display "Right Click to
Choose Code" When the user's click on the list it will display all the
autotext associated with that style.

i want to be able to pull the autotextlist from a database table based on
the "style" this will allow me to update the table since it will change over
time.

any suggestions on the best way to handle this? I've done the autotextlist
many times, but, not pulling it from a DB.

thanks

Joe

 

[Joe]

Ok, i found the two videos on "how to" create custom ribbons in office 2007.
one is a c# example and one is a VB. i have compiled both and when i install
them neither of the "custom" ribbons show up? is this a known bug? am i
missing something? i used
http://go.microsoft.com/?linkid=5519367

and http://go.microsoft.com/?linkid=5519366

I went step by step and did not change a single line of code. no compile
error.

BTW, i'm using Visual Studio 2005 with teh v3 CTP for 0ffice 2007.

 

[Patrick Schmid [MVP]]

Probably the same issue I have with my blog: All the idMso's need to be
updated after B2TR. What is the example RibbonX they used in one of the
examples? Post it here and I'll fix it to work with B2TR.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 Beta 2 Technical Refresh (B2TR):
http://pschmid.net/blog/2006/09/18/43
***
Customize Office 2007: http://pschmid.net/office2007/customize
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

 

[Joe]

It's a simple example of adding a ribbon add-in in Visual Studio 2005. The
code is on my other machine. is there a place to go and download the
idMso's? or do we wait for a patch? if not i'll post it on Wed. As long as
it's not just my "fat fingers" coding, i feel better now. LOL

Joe

Probably the same issue I have with my blog: All the idMso's need to be
updated after B2TR. What is the example RibbonX they used in one of the
examples? Post it here and I'll fix it to work with B2TR.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 Beta 2 Technical Refresh (B2TR):
http://pschmid.net/blog/2006/09/18/43
***
Customize Office 2007: http://pschmid.net/office2007/customize
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

Ok, i found the two videos on "how to" create custom ribbons in office 2007.
one is a c# example and one is a VB. i have compiled both and when i install
them neither of the "custom" ribbons show up? is this a known bug? am i
missing something? i used
http://go.microsoft.com/?linkid=5519367

and http://go.microsoft.com/?linkid=5519366

I went step by step and did not change a single line of code. no compile
error.

BTW, i'm using Visual Studio 2005 with teh v3 CTP for 0ffice 2007.

 

[Patrick Schmid [MVP]]

Why a patch? Nothing is broken in Office. Just the documentation is out
of date.
If you take a look at my B2TR page, there is a link to the new Control
ID list somewhere in there. That's what you want to download and use.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 Beta 2 Technical Refresh (B2TR):
http://pschmid.net/blog/2006/09/18/43
***
Customize Office 2007: http://pschmid.net/office2007/customize
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

It's a simple example of adding a ribbon add-in in Visual Studio 2005. The
code is on my other machine. is there a place to go and download the
idMso's? or do we wait for a patch? if not i'll post it on Wed. As long as
it's not just my "fat fingers" coding, i feel better now. LOL

Joe

Probably the same issue I have with my blog: All the idMso's need to be
updated after B2TR. What is the example RibbonX they used in one of the
examples? Post it here and I'll fix it to work with B2TR.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 Beta 2 Technical Refresh (B2TR):
http://pschmid.net/blog/2006/09/18/43
***
Customize Office 2007: http://pschmid.net/office2007/customize
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

Ok, i found the two videos on "how to" create custom ribbons in office 2007.
one is a c# example and one is a VB. i have compiled both and when i install
them neither of the "custom" ribbons show up? is this a known bug? am i
missing something? i used
http://go.microsoft.com/?linkid=5519367

and http://go.microsoft.com/?linkid=5519366

I went step by step and did not change a single line of code. no compile
error.

BTW, i'm using Visual Studio 2005 with teh v3 CTP for 0ffice 2007.

 

[Cindy M.]

Hi Joe,

i want to be able to pull the autotextlist from a database table based on
the "style" this will allow me to update the table since it will change over
time.

any suggestions on the best way to handle this? I've done the autotextlist
many times, but, not pulling it from a DB.

I suggest you go to either the word.programming or the
office.developer.automation newsgroup with this question. Docmanagement (or
"general questions" in some web interfaces) is targeted at end-users. You're
more likely to get a good discussion going in a programming group

Since you're working in the .NET environment, the Automation group is probably
the better bet. Can you be more specific about what you have in mind for the
"database" and what stumbling blocks you're encountering? I'm not sure what kind
of input you're looking for, based on the little you tell us, here.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[Bob Buckland ?:-\)]

Hi Joe,

While this Add-in is for Outlook 2007 B2TR it can be helpful in working through some examples of RibbonX customization
http://microsoft.com/downloads/deta...bf-48dc-4f73-8f6b-62b4482a92bc&DisplayLang=en

You'll find the control ID downloads available about 1/2 way down this page
http://msdn.microsoft.com/office/future/tools/

==========
It's a simple example of adding a ribbon add-in in Visual Studio 2005. The
code is on my other machine. is there a place to go and download the
idMso's? or do we wait for a patch? if not i'll post it on Wed. As long as
it's not just my "fat fingers" coding, i feel better now. LOL

Joe >>
--
I hope this helped you,

Bob Buckland ?
MS Office system products MVP

LINKS to the 2007 Office System

1. Free MS Office 2007 book from MS Press, 213 pages:
http://microsoft.com/learning/office2007/default.mspx#booksfrommspress

2.. Office 2007 Beta 2 Online Test Drive, Downloadable beta,
e-learning courses, doucmentation and movies:
http://microsoft.com/office/preview

3. Send 2007 Office System Beta 2 feedback directly to the MS Office 2007 product team with this feedback tool:
http://sas.office.microsoft.com/

4. Try the 2007 OfficeOnline preview website , without Office2007

a. Install the ActiveX access control
http://office.microsoft.com/search/redir.aspx?AssetID=XT101650581033

b. then visit
http://officebeta.iponet.net