..:: a button ::..

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cartoonsmart - 16 Jan 2007 08:59 GMT

Hi I like to create a button that opens a doc based on a specific template.
How can I do this? Tutorials anyone? How would the VBA code look like?
Thanks for your help.

Regards
Kevin form the Netherlands

Reply to this Message

Graham Mayor - 16 Jan 2007 11:53 GMT

This would be re-inventing the wheel, as the filenew dialog already provides
such buttons (or shortcuts). However if you want to grow your own: You need
the line

Documents.Add Template:="c:\path\templatename.dot"

in a macro attached to a toolbar button
http://www.gmayor.com/installing_macro.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Hi I like to create a button that opens a doc based on a specific
> template. How can I do this? Tutorials anyone? How would the VBA code
> look like? Thanks for your help.
>
> Regards
> Kevin form the Netherlands

Reply to this Message

cartoonsmart - 16 Jan 2007 17:58 GMT

Ofcourse you are right.
But the thing is I am helping out a friend, who is not at all familiar with
Word, with his business. That is... like many people he's able to write text
in Word and hard format it, that's about it. I can't ask him to preform an
action like open new document based on a template and look for the
template - that's what you mean right? Now he has buttons (within
Normal.dot) on his menubar that he clicks, and then provide him with a
document based on a customized template - I believe that's user friendly, or
am I wrong?

Thanks for your feedback. I am not at all a Word wiz but throughout the last
5 years I have now and again read a lot of MVP made material. I am still
studying at a university, and if you could see how people work with Word...
well let's just say with only my know how from MVP tutorials people think I
am pulling of magic tricks! And I don't even know proper VBA.

Oh btw maybe this is not the right place. But sometime ago I did some
spreadsheet modeling in Excel. Now I had this really cool workbook or
workmap - I am Dutch so I don't immediately know what the term is for a
collection of sheets in a .xls file. The first sheet contained a sort of
swithboard - well not a real switchboard like in a database but a collection
of buttons - wich allowed a user to navigate through the sheets, just for
fun! But I seem to have lost it! Could you tell me what VBA code I need to
assign to tell a button in Excel to direct the user after clicking to
another sheet within the same workbook?

Thanks again.

> This would be re-inventing the wheel, as the filenew dialog already
> provides such buttons (or shortcuts). However if you want to grow your
[quoted text clipped - 11 lines]
>> Regards
>> Kevin form the Netherlands

Reply to this Message

Suzanne S. Barnhill - 16 Jan 2007 19:38 GMT

My husband is not very adept at Word, and what he finds helpful is to have
shortcuts to templates on the desktop. This is a good solution for people
who don't keep Word open all the time but just open Word specifically to
create a particular type of document (letter or envelope, for example). When
you double-click on a template shortcut, Word opens with a document based on
that template.

Signature

Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

> Ofcourse you are right.
> But the thing is I am helping out a friend, who is not at all familiar with
[quoted text clipped - 39 lines]
> >> Regards
> >> Kevin form the Netherlands

Reply to this Message

cartoonsmart - 16 Jan 2007 20:39 GMT

This is what I came up with for excel...

Private Sub CommandButton1_Click()
Sheets("Blad2").Select
End Sub

< btw thanx Suzanne for the tip...that migh ofcourse be very handy when many
documents are involved, since buttons for each doc would clutter up the
interface>

> My husband is not very adept at Word, and what he finds helpful is to have
> shortcuts to templates on the desktop. This is a good solution for people
[quoted text clipped - 57 lines]
>> >> Regards
>> >> Kevin form the Netherlands

Reply to this Message

Shauna Kelly - 18 Jan 2007 12:59 GMT

Hi cartoonsmart

The easiest way to create a button to go to a worksheet in Excel is to
create a textbox from the Drawing menu. Format it to suit your needs. Then
right-click, choose Hyperlink, and create a hyperlink to the worksheet.

Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word

> This is what I came up with for excel...
>
[quoted text clipped - 72 lines]
>>> >> Regards
>>> >> Kevin form the Netherlands

Reply to this Message

cartoonsmart - 16 Jan 2007 20:51 GMT

Quick question: as MVP's do you think it is good practice to have 'fill in'
fields within booksmarks. So that when I fill field 'X' I can insert a 'ref'
field somewhere else in the doc wich then contains the same data as the
refered 'fill in' field.

> Hi I like to create a button that opens a doc based on a specific
> template.
[quoted text clipped - 3 lines]
> Regards
> Kevin form the Netherlands

Reply to this Message

Suzanne S. Barnhill - 16 Jan 2007 22:24 GMT

See http://gregmaxey.mvps.org/Repeating_Data.htm for a number of ways of
accomplishing this.

Signature

> Quick question: as MVP's do you think it is good practice to have 'fill in'
> fields within booksmarks. So that when I fill field 'X' I can insert a 'ref'
[quoted text clipped - 8 lines]
> > Regards
> > Kevin form the Netherlands

Reply to this Message

cartoonsmart - 17 Jan 2007 10:56 GMT

So I have studied the text.

A FILLIN field fires a prompt when a new document is created based on a template containing the FILLIN field, when a document containing a FILLIN field is opened, and (very unfortunately) when you print a document containing a FILLIN field if the "Update Fields" option is checked in File>Print>Options>Printing Options.

Now about the above. If I uncheck the "update fields" option the problem is solved right? I can then just fill in the forms and print the doc with the propper data.
If I understand the text in the article correct I should nest the FILL IN fields in SET fields. However for referencing purposes I did this [BOOK{FILL IN}MARK] {REF}

> See http://gregmaxey.mvps.org/Repeating_Data.htm for a number of ways of
> accomplishing this.
[quoted text clipped - 13 lines]
>> > Regards
>> > Kevin form the Netherlands

Reply to this Message

Suzanne S. Barnhill - 17 Jan 2007 15:22 GMT

Greg will have to answer this one, as I gave up on FILLIN fields long ago. I
assume that you don't want to use a protected form for this project?

Signature

So I have studied the text.

A FILLIN field fires a prompt when a new document is created based on a
template containing the FILLIN field, when a document containing a FILLIN
field is opened, and (very unfortunately) when you print a document
containing a FILLIN field if the "Update Fields" option is checked in
File>Print>Options>Printing Options.

Now about the above. If I uncheck the "update fields" option the problem is
solved right? I can then just fill in the forms and print the doc with the
propper data.
If I understand the text in the article correct I should nest the FILL IN
fields in SET fields. However for referencing purposes I did this [BOOK{FILL
IN}MARK] {REF}

"Suzanne S. Barnhill" <sbarnhill@mvps.org> schreef in bericht
news:eH07M0bOHHA.780@TK2MSFTNGP03.phx.gbl...

> See http://gregmaxey.mvps.org/Repeating_Data.htm for a number of ways of
> accomplishing this.
[quoted text clipped - 15 lines]
>> > Regards
>> > Kevin form the Netherlands

Reply to this Message