Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-21-2012, 12:21 AM
macropod's Avatar
macropod macropod is offline Form file timesheet, auto fill date from calander Windows 7 64bit Form file timesheet, auto fill date from calander Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
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

Hi Jeannie,



Word really isn't the tool for this sort of thing - Excel is far better suited, being able to perform all the required calculations as well using its inbuilt functions (all of which would have to be coded in Word.

If you want to see what's involved in getting Word to do date-based calculations for something as seemingly simple as incrementing a date, check out my Microsoft Word Date Calculation Tutorial, at:
http://lounge.windowssecrets.com/ind...owtopic=249902
or
http://www.gmayor.com/downloads.htm#Third_party
In particular, look at the items titled 'Calculate a Date Sequence' and 'Date and Time Calculations In A Word Form'. Do read the document's introductory material.

An alternative would be to use a macro. This would be much simpler, but has the disadvantage that they are easily disabled.

My recommendation: Use Excel. There are many Excel timesheet templates available on the web that could be adapted to your needs.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Form file timesheet, auto fill date from calander Help with fill in form RetiredFD Word 1 03-18-2012 12:52 AM
Can you auto fill pictures into a slide show? darkcyber PowerPoint 0 07-20-2011 09:11 PM
Prompts to auto-fill name of contacts crystaldb Office 4 05-21-2011 06:16 PM
fill in form + forwarding to another email Snowboarder Outlook 0 05-27-2010 04:39 PM
Word Fill-in form with Excel spreadsheet karik Word 0 01-11-2010 08:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:07 PM.


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