Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-04-2015, 12:34 PM
brojames brojames is offline Creating a Template using a Macro to fill in various information Windows 10 Creating a Template using a Macro to fill in various information Office 2016
Novice
Creating a Template using a Macro to fill in various information
 
Join Date: Nov 2015
Location: Gulf Coast of Texas
Posts: 7
brojames is on a distinguished road
Question Creating a Template using a Macro to fill in various information

Not to offend, but in WordPerfect I have created documents with a macro that allows me to open the template as a document and provides boxes I can type in the desired info and it is placed where it belongs.

I want to do that in Word 2016, but have not been able to find out how. I am not a programmer so I do not know how to do programming.

To explain what I want, I am a retired pastor and do the Sunday bulletin. In WP I can create a "Fill in" macro that allows me to set up all the Hymn #'s and Titles in separate boxes, along with dates that change from week to week.

BUT, I want to make use of Word 2016, so I hope someone can provide me with "clear instructions" on how to do this.

Thank you in advance,
BroJames
Reply With Quote
  #2  
Old 11-04-2015, 06:53 PM
Charles Kenyon Charles Kenyon is offline Creating a Template using a Macro to fill in various information Windows 8 Creating a Template using a Macro to fill in various information Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,463
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Before we go furher, read this:
Word for Wordperfect Users
You do not want to use the Word Fill-In or Ask fields. They are way too cumbersome for ordinary use.

What you are looking for here is a custom dialog box called a UserForm.
Create a Simple Userform
Create & Employ a Userform

By the way, template is a term of art in Word. To use a template properly, you double-click on it. This creates a new document based on (and attached to) the template. You can use an AutoNew macro to trigger the userform when this happens.
Templates in Microsoft Word

Last edited by Charles Kenyon; 11-05-2015 at 11:43 AM.
Reply With Quote
  #3  
Old 11-04-2015, 07:55 PM
macropod's Avatar
macropod macropod is offline Creating a Template using a Macro to fill in various information Windows 7 64bit Creating a Template using a Macro to fill in various information Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,359
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

For more specific advice, it would be helpful if could you attach a document to a post with some representative content (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 11-04-2015, 08:45 PM
brojames brojames is offline Creating a Template using a Macro to fill in various information Windows 10 Creating a Template using a Macro to fill in various information Office 2016
Novice
Creating a Template using a Macro to fill in various information
 
Join Date: Nov 2015
Location: Gulf Coast of Texas
Posts: 7
brojames is on a distinguished road
Default

Thanks Charles, for the links to the documents. I will study them and hopefully learn how to create/convert what I am doing to Word. Let you know how I do.
BroJames
Reply With Quote
  #5  
Old 11-04-2015, 09:17 PM
brojames brojames is offline Creating a Template using a Macro to fill in various information Windows 10 Creating a Template using a Macro to fill in various information Office 2016
Novice
Creating a Template using a Macro to fill in various information
 
Join Date: Nov 2015
Location: Gulf Coast of Texas
Posts: 7
brojames is on a distinguished road
Default WP Document as Sample

Paul,

I have saved a WP document as a Doc and hopefully it will show what I am talking about.
In the document I colored the areas red that I fill in through dialog boxes that then puts the info in the correct place.
I'm not good for explaining what I am trying to do, but I appreciate your help and will attempt to follow all directions.
Thanks again,
BroJames
Attached Files
File Type: doc WP Document.doc (336.0 KB, 17 views)
Reply With Quote
  #6  
Old 11-04-2015, 11:00 PM
gmayor's Avatar
gmayor gmayor is offline Creating a Template using a Macro to fill in various information Windows 7 64bit Creating a Template using a Macro to fill in various information Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,137
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

This could easily be done with a userform or with content controls, but it would make things simpler if you have a list of the hymns with their numbers to select from.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #7  
Old 11-05-2015, 07:01 AM
brojames brojames is offline Creating a Template using a Macro to fill in various information Windows 10 Creating a Template using a Macro to fill in various information Office 2016
Novice
Creating a Template using a Macro to fill in various information
 
Join Date: Nov 2015
Location: Gulf Coast of Texas
Posts: 7
brojames is on a distinguished road
Default

Graham,

As to the hymns, I use the index in the hymnal to get the titles and page numbers. The dates are future from the time I create the bulletin.

I'll look at your web site to see what you have there. Thanks for your response.
BroJames
Reply With Quote
  #8  
Old 11-09-2015, 02:51 PM
brojames brojames is offline Creating a Template using a Macro to fill in various information Windows 10 Creating a Template using a Macro to fill in various information Office 2016
Novice
Creating a Template using a Macro to fill in various information
 
Join Date: Nov 2015
Location: Gulf Coast of Texas
Posts: 7
brojames is on a distinguished road
Default

Thanks for your replies, I'm still working on this and will get back to you as soon as I am successful. I just know I will be successful even though I know NOTHING about Code.
Reply With Quote
Reply

Tags
macro find and replace, template document styles



Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a Template using a Macro to fill in various information Creating a Document that Pushes Information to other Word Documents jbwhisler Word 2 08-25-2015 12:12 AM
fill in blank information crussell Mail Merge 8 11-11-2014 02:59 PM
Creating a Template using a Macro to fill in various information When creating new template from established template macros getting lost. TechEd Word 3 06-09-2014 07:22 PM
Creating a Template using a Macro to fill in various information Creating custom label fill-able template JWaa@Auroracasket Word 2 12-13-2013 10:48 AM
Creating document from template but macros are still linked to template webharvest Word 0 07-16-2011 09:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:05 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft