Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-03-2018, 04:44 AM
macropod's Avatar
macropod macropod is offline Word form with the intent of Excel export Windows 7 64bit Word form with the intent of Excel export Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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

Quote:
Originally Posted by Flyckten View Post
All this is inserted in a word document along with a simplified excel-sheet where the bidders are supposed to out answer. It is made in excel due to the answers result in points and is later used for evaluation purposes.
Quite unnecessary, since Word can also do quite complex calculations using formfields & field coding, for example.


To see how to do a wide range of calculations in Word, check out my Microsoft Word Field Maths Tutorial: https://www.msofficeforums.com/word/...-tutorial.html
For a demo of what can be done in the realm of point calculations, see: https://www.msofficeforums.com/word/...html#post74823
And, for date calculations, should you need them, check out my Microsoft Word Date Calculation Tutorial: https://www.msofficeforums.com/word/...-tutorial.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 09-03-2018, 05:11 AM
Flyckten Flyckten is offline Word form with the intent of Excel export Windows 10 Word form with the intent of Excel export Office 2016
Novice
Word form with the intent of Excel export
 
Join Date: Sep 2018
Posts: 4
Flyckten is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Quite unnecessary, since Word can also do quite complex calculations using formfields & field coding, for example.
To see how to do a wide range of calculations in Word, check out my Microsoft Word Field Maths Tutorial: https://www.msofficeforums.com/word/...-tutorial.html
For a demo of what can be done in the realm of point calculations, see: https://www.msofficeforums.com/word/...html#post74823
And, for date calculations, should you need them, check out my Microsoft Word Date Calculation Tutorial: https://www.msofficeforums.com/word/...-tutorial.html
Seems like a good way when you only have some fields that needs to be added. When working with 3-400 requirements that needs to be summarized it seems to be easier to use excel, instead of using a field code similar to: {={DropDownReq1}+{DropDownReq2}+{DropDownReq3}+... +{DropDownReq400}}

Or is there any great summary formulas that I missed?
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Word form with the intent of Excel export Export Word Drop-Down Content Control to Excel Specific Sheet nolanthomas32 Word VBA 4 09-19-2017 06:25 AM
Word form with the intent of Excel export VBA Export Data as Text from Excel to Word lwbarnes Word VBA 3 06-09-2016 02:47 PM
Word form with the intent of Excel export Export Word Form Data to Access pboland Word VBA 1 06-12-2015 06:53 PM
Export VBA form Data to CSV rhys.downard Outlook 0 02-29-2012 07:35 AM
Through VBA, export range from Excel to Word duugg Word VBA 0 08-24-2009 07:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:50 AM.


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