Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Create date based checklists for printing
I have created a document which is a checklist to be compleated everyweekday
by employees. I want to print out the checklists one month in advance so they can be put in a binder. Does anyone have an idea on how I can insert the dates to the documents without mauanlly editing the document each time? Regards, Hari |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Create date based checklists for printing
Dear Hari,
Unfortunately this cannot be accomplished by fields only; you have to use VBA as well. I suggest you put this macro in the template you're using (you may have to use the macro under B if you use Word 2002 or earlier): A. Sub AutoNew() ActiveDocument.Variables("Date28").Value = _ Format(Date + 28, "dd-MMMM-yyyy") ActiveDocument.Fields.Update End Sub B. Sub AutoNew() On Error GoTo ErrorTrap_AutoNew: ActiveDocument.Variables("Date28").Value = _ Format(Date + 28, "dd-MMMM-yyyy") ActiveDocument.Fields.Update Exit Sub ErrorTrap_AutoNew: ActiveDocument.Variables.Add Name:="Date28", _ Value:=Format(Date + 28, "dd-MMMM-yyyy") Resume Next End Sub Place this field in your document where you want to have your 'date + 28 days': { DOCVARIABLE Date28 } Be sure to insert { } by means of pressing Ctrl-F9. Success, Cooz -- PS: If this is a satisfying answer to your question and you're logged in via the Microsoft site, please click Yes to "Did this post answer the question?". Thanks. "Hari" wrote: I have created a document which is a checklist to be compleated everyweekday by employees. I want to print out the checklists one month in advance so they can be put in a binder. Does anyone have an idea on how I can insert the dates to the documents without mauanlly editing the document each time? Regards, Hari |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Create date based checklists for printing
You would need a 31-page document with calculated date fields. This is more
complex than you might imagine, but it can be done. See http://addbalance.com/word/datefields2.htm for information on the different kinds of ways to make a date calculation work. It includes links to utilities to create the fields and an explanation of different macros that can be used instead of fields. It also has a link to http://www.wopr.com/cgi-bin/w3t/show...?Number=249902 which is a document with various fields already created. -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "Hari" wrote in message ... I have created a document which is a checklist to be compleated everyweekday by employees. I want to print out the checklists one month in advance so they can be put in a binder. Does anyone have an idea on how I can insert the dates to the documents without mauanlly editing the document each time? Regards, Hari |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Create date based checklists for printing
Actually, if you're doing this on a per-calendar-month basis (and don't need
general case date addition logic) the field codes aren't that horrendous. -- Enjoy, Tony "Charles Kenyon" wrote in message ... You would need a 31-page document with calculated date fields. This is more complex than you might imagine, but it can be done. See http://addbalance.com/word/datefields2.htm for information on the different kinds of ways to make a date calculation work. It includes links to utilities to create the fields and an explanation of different macros that can be used instead of fields. It also has a link to http://www.wopr.com/cgi-bin/w3t/show...?Number=249902 which is a document with various fields already created. -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "Hari" wrote in message ... I have created a document which is a checklist to be compleated everyweekday by employees. I want to print out the checklists one month in advance so they can be put in a binder. Does anyone have an idea on how I can insert the dates to the documents without mauanlly editing the document each time? Regards, Hari |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Create date based checklists for printing
They could be simpler than many such fields, but far from simple. You simply
would only use a month and year formatted field and manually enter the day portion for each. The Formatting Date Fields section of http://word.mvps.org/FAQs/TblsFldsFms/DateFields.htm shows the switches to pick out only the month and year in a date field. I expect that the original poster would want the current month plus one in order to print such a calendar before the month actually starts. If you are going to also use the field for the year, you would still be testing for the end of the year. On reflection, my thought would be that it would probably be easier (at least as far as setting it up) to simply type dates into the template rather than use fields and then do a replace when you actually create a document based on the template. It would be relatively simple to have an AutoNew macro query the user as to the month and year that would be used and have that macro do the replace. -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "Tony Jollans" My Forename at My Surname dot com wrote in message ... Actually, if you're doing this on a per-calendar-month basis (and don't need general case date addition logic) the field codes aren't that horrendous. -- Enjoy, Tony "Charles Kenyon" wrote in message ... You would need a 31-page document with calculated date fields. This is more complex than you might imagine, but it can be done. See http://addbalance.com/word/datefields2.htm for information on the different kinds of ways to make a date calculation work. It includes links to utilities to create the fields and an explanation of different macros that can be used instead of fields. It also has a link to http://www.wopr.com/cgi-bin/w3t/show...?Number=249902 which is a document with various fields already created. -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "Hari" wrote in message ... I have created a document which is a checklist to be compleated everyweekday by employees. I want to print out the checklists one month in advance so they can be put in a binder. Does anyone have an idea on how I can insert the dates to the documents without mauanlly editing the document each time? Regards, Hari |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Create date based checklists for printing
I would do this as a mail merge from Excel. Create a data source in Excel
that can be updated each month (see http://word.mvps.org/FAQs/MailMerge/...DataSource.htm). Each record in Excel will contain a single field, the date. Excel allows you to insert the dates via AutoFill and specify weekdays, as follows: Create a consecutive list of dates 1. Type the first day or date in the list, for example Monday or 6/13/08, in a cell. 2. Select the cell and use the fill handle to fill a list of consecutive days. Note: If you want only weekdays in your list, click Auto Fill Options and then select Fill Weekdays only. In your mail merge main document (use a Letter merge), insert a merge field where you want the date. When you create the merge, you'll get a document with a page/section for each weekday. -- 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. "Hari" wrote in message ... I have created a document which is a checklist to be compleated everyweekday by employees. I want to print out the checklists one month in advance so they can be put in a binder. Does anyone have an idea on how I can insert the dates to the documents without mauanlly editing the document each time? Regards, Hari |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic date change | Microsoft Word Help | |||
Word modified date is less than create date | Microsoft Word Help | |||
The Web Archive Converter puts todays date on MHT copies of old f | Microsoft Word Help | |||
How to insert future date based on current date plus 14 days | Microsoft Word Help | |||
What is a create date? | Microsoft Word Help |