+ Reply to Thread
Results 1 to 2 of 2

Populating DocProperty fields in second Word Document from current document

  1. #1
    Forum Contributor
    Join Date
    05-08-2009
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    223

    Populating DocProperty fields in second Word Document from current document

    I have a userform that allows a user to populate a number of DocProperty fields in a document (Document A).

    Once this step is complete the document is then emailed to an authoriser who completes other fields manually and then passes it back to the user.

    A further document (Document B) is then opened and fields from document A have to be manually copied across into the relevant sections of document B. The 'common' fields are a mixture of DocProperty fields and the manual fields completed by the authoriser.

    Is there any way this could be automated via a commandbutton in document A without having to 'build' document B from scratch in vba to create it when the commandbutton is clicked?

    Thank you.

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Populating DocProperty fields in second Word Document from current document

    You could use a macro like the following for the transfer:
    Please Login or Register  to view this content.
    Simply add the above macro to the template you use to create the primary document. Then, when the primary document is returned, open both that and the destination document, ensuring the primary document is active before running the macro. No other documents should be open.

    For PC macro installation & usage instructions, see: http://www.gmayor.com/installing_macro.htm
    For Mac macro installation & usage instructions, see: https://wordmvp.com/Mac/InstallMacro.html
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel fields to a Word document set of fields?
    By brucemc777 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-06-2014, 02:09 PM
  2. Replies: 2
    Last Post: 04-19-2013, 07:02 AM
  3. Add text to Existing Word Document if it Doesn't exist create Word Document
    By unstable81 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-10-2013, 12:15 AM
  4. export cell contents to Word fields in a protected Word document
    By duugg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-31-2011, 09:31 AM
  5. Excel to Populate Word Form Fields & Document
    By D1TrueGod in forum Excel General
    Replies: 2
    Last Post: 10-25-2009, 01:07 PM
  6. Replies: 0
    Last Post: 02-06-2006, 05:30 PM
  7. Word found no merge fields in your main document.
    By lburg801 in forum Excel General
    Replies: 0
    Last Post: 11-28-2005, 04:01 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1