a set of date fields that update from week to week.

[cmptrbil]

Hello all,
I am trying to improve the timesheet our employees use. We use a bi-weekly
sheet and every time the employees open the file to print it out they have to
type in all of the dates for that particular time period. What is the best
way to automate this? I haven't done much programming for the office but I
have done back-end web programming so don't be afraid to get too technical,(
I can always just ask more questions).
Bill

 

[Graham Mayor]

I would use Excel for this, however you can set dates with fields in the
document template or with a macro -
http://www.gmayor.com/insert_a_date_other_than_today.htm should give you
some ideas (note the link in the first section).

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Beth Melton]

Is there a reason you are constructing the dates yourself and aren't
using the DateAdd function in your macro. Have you found the DateAdd
function to be incorrect?

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

 

[Graham Mayor]

DateAdd works just fine. The macro is an old one which evolved over time and
I haven't bothered to update it as it works. I included the link as it
contains a link to Macropod's work on fields which saved me the trouble of
looking up the follow-on link to his work.

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>