Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-17-2017, 02:11 PM
1questionman 1questionman is offline Macro: automate a contract? Windows 7 64bit Macro: automate a contract? Office 2013
Novice
Macro: automate a contract?
 
Join Date: Oct 2017
Posts: 2
1questionman is on a distinguished road
Question Macro: automate a contract?

Hello wise human ,



(FYI I have the necessary experience with excel vba)

I need to automate a contract by letting the user choose the details from dropdown menus (with a combobox) and with that info populate the word document.

this necessity arose from the fact that every time they write a work contract they have to fill in every detail and then review it all over again to make sure it is correct.

By creating a Word VBA solution with a combobox + drop down menus, I could use a macro to either write the whole contract with it or just fill in a doc certain spots with the drop down menu selections.


Question: Does anyone have a document similar to this that I can use to base my solution on? or is the excel VBA process the same as word and I should use an excel guide to produce my word VBA solution?

Last edited by 1questionman; 10-17-2017 at 08:07 PM.
Reply With Quote
  #2  
Old 10-17-2017, 04:47 PM
macropod's Avatar
macropod macropod is offline Macro: automate a contract? Windows 7 64bit Macro: automate a contract? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

See, for example:
https://www.msofficeforums.com/word-...html#post46903
https://www.msofficeforums.com/word-...tml#post120392
https://www.msofficeforums.com/word-...tml#post119172
https://www.msofficeforums.com/word-...tml#post119230
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 10-17-2017, 08:16 PM
1questionman 1questionman is offline Macro: automate a contract? Windows 7 64bit Macro: automate a contract? Office 2013
Novice
Macro: automate a contract?
 
Join Date: Oct 2017
Posts: 2
1questionman is on a distinguished road
Default

I saw the posts but they do not comply with the request yet because what's needed is either:

A) a document that has a little button at the top that when it's clicked it opens a combobox asking for a few details to populate the document with the whole contract + the specific details selected in the combobox

B) same button but it just modifies the specific details selected in the combobox, in the document which already has the contract template

Is this viable? sounds easy but I have not found a guide for this
Reply With Quote
  #4  
Old 10-17-2017, 08:29 PM
gmayor's Avatar
gmayor gmayor is offline Macro: automate a contract? Windows 10 Macro: automate a contract? Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

See http://www.gmayor.com/Userform.htm especially the section on bookmarks.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to automate changes to slide Mearsy PowerPoint 0 08-18-2015 03:29 AM
automate macro for merged document (after merge) eibst Word VBA 1 06-05-2015 11:36 PM
Deciding on the best way to automate a long contract. tmneal74 Word 1 08-15-2012 12:26 PM
Macro: automate a contract? Creating a contract todd.denoyer Word 3 05-05-2011 04:53 PM
Macro: automate a contract? Can I automate or make a macro for this? mkoenig Word VBA 1 01-31-2010 02:47 AM

Other Forums: Access Forums

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


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft