#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
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 |
#4
|
||||
|
||||
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 |
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 |
Creating a contract | todd.denoyer | Word | 3 | 05-05-2011 04:53 PM |
Can I automate or make a macro for this? | mkoenig | Word VBA | 1 | 01-31-2010 02:47 AM |