PC Review


Reply
Thread Tools Rate Thread

Create date based checklists for printing

 
 
=?Utf-8?B?SGFyaQ==?=
Guest
Posts: n/a
 
      24th Feb 2006
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 With Quote
 
 
 
 
=?Utf-8?B?Q29veg==?=
Guest
Posts: n/a
 
      24th Feb 2006
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

 
Reply With Quote
 
Charles Kenyon
Guest
Posts: n/a
 
      24th Feb 2006
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" <(E-Mail Removed)> wrote in message
news:1F286500-4F84-45D5-853C-(E-Mail Removed)...
>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 With Quote
 
Tony Jollans
Guest
Posts: n/a
 
      24th Feb 2006
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" <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:1F286500-4F84-45D5-853C-(E-Mail Removed)...
> >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 With Quote
 
Charles Kenyon
Guest
Posts: n/a
 
      24th Feb 2006
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
news:evk$(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:#(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message
>> news:1F286500-4F84-45D5-853C-(E-Mail Removed)...
>> >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 With Quote
 
Suzanne S. Barnhill
Guest
Posts: n/a
 
      24th Feb 2006
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" <(E-Mail Removed)> wrote in message
news:1F286500-4F84-45D5-853C-(E-Mail Removed)...
> 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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create new records based on a date Bobbye R Microsoft Access Queries 2 22nd Mar 2009 02:45 AM
VBA to create dir's based on 'date picture taken' Tim Microsoft Excel Programming 1 1st Sep 2008 10:04 PM
create new record based on date =?Utf-8?B?Q2Fycmll?= Microsoft Access Form Coding 4 30th May 2007 04:28 AM
Re: Create a formula based on date Bob Phillips Microsoft Excel Worksheet Functions 0 8th Jan 2007 04:47 PM
Re: Create a formula based on date David Biddulph Microsoft Excel Worksheet Functions 0 8th Jan 2007 04:44 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:42 AM.