Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Would like to know if it is possible and if so how to automatically calculate
the totals for a time card template. |
#2
![]() |
|||
|
|||
![]()
CheifNewB,
To automate the calculation you will need to set up your template as a protected form. You should get a good start here and the linked articles by Dian Chapman: http://word.mvps.org/faqs/customizat...nTheBlanks.htm You can semi-automate calculations using formula fields and then updating the fields. Let's say the hours worked are in a column. At the bottom put the field {=sum(above)}. The field code braces { } are entered with CTRL+F9. Toggle the field code to display the result with ALT+F9. When a change is made, you can update the field by selecting the field and pressing F9, or update all fields by pressing CTRL+a (selects all) and pressing F9, toggling to and from print preview (if "Update Fields" is checked in the FilePrintOptions dialog box), or running a macro something like: Sub UpdateFields() Dim oStory As Range For Each oStory In ActiveDocument.StoryRanges oStory.Fields.Update If oStory.StoryType wdMainTextStory Then While Not (oStory.NextStoryRange Is Nothing) Set oStory = oStory.NextStoryRange oStory.Fields.Update Wend End If Next oStory Set oStory = Nothing End Sub -- Greg Maxey/Word MVP A Peer in Peer to Peer Support ChiefNewB wrote: Would like to know if it is possible and if so how to automatically calculate the totals for a time card template. |
#3
![]() |
|||
|
|||
![]()
But note that if you're trying to add times, you may need to embed an Excel
sheet instead of using Word's fields. -- 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. "Greg Maxey" wrote in message ... CheifNewB, To automate the calculation you will need to set up your template as a protected form. You should get a good start here and the linked articles by Dian Chapman: http://word.mvps.org/faqs/customizat...nTheBlanks.htm You can semi-automate calculations using formula fields and then updating the fields. Let's say the hours worked are in a column. At the bottom put the field {=sum(above)}. The field code braces { } are entered with CTRL+F9. Toggle the field code to display the result with ALT+F9. When a change is made, you can update the field by selecting the field and pressing F9, or update all fields by pressing CTRL+a (selects all) and pressing F9, toggling to and from print preview (if "Update Fields" is checked in the FilePrintOptions dialog box), or running a macro something like: Sub UpdateFields() Dim oStory As Range For Each oStory In ActiveDocument.StoryRanges oStory.Fields.Update If oStory.StoryType wdMainTextStory Then While Not (oStory.NextStoryRange Is Nothing) Set oStory = oStory.NextStoryRange oStory.Fields.Update Wend End If Next oStory Set oStory = Nothing End Sub -- Greg Maxey/Word MVP A Peer in Peer to Peer Support ChiefNewB wrote: Would like to know if it is possible and if so how to automatically calculate the totals for a time card template. |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I divide a page into three sections? | Microsoft Word Help | |||
word xp crashes after macros are recorded | Microsoft Word Help | |||
WordPerfect - copying formatting | Page Layout | |||
Continuous breaks convert to next page breaks | Microsoft Word Help | |||
macro in word | Microsoft Word Help |