+ Reply to Thread
Results 1 to 1 of 1

Transfer excel data to word template

  1. #1
    Registered User
    Join Date
    05-22-2016
    Location
    Saudi Arabia
    MS-Off Ver
    2016
    Posts
    6

    Lightbulb Transfer excel data to word template

    B C D E
    10 Contract_Type Company Name Contract period Employee Name
    11 Unlimited Google Adam
    12 imited Apple 2Years John
    13 ForFemale Daycare Celiena

    Hello,
    I’m a new to excel VBA and would appreciate it greatly if someone could assist me in this issue.
    I have the above table in excel start in "B10" and it is populated when a user completes a userform and clicks a 'Save' Button.(I have multiple userform and one database ).
    Once they have saved an 'Export' button is enabled and the user can export the last record (row) submitted by the user form to word template in the relevant locations on the template (I want to open different templates based on Contract Type).

    I have created bookmarks in the attached word templates and would like the data to be exported to these locations.
    1. ( Contract_Type ,Company Name and Employee Name) for the Unlimited and for female contracts .
    2. (Contract_Type ,Company Name, Contract period and Employee Name) for the Limited contract .
    Last edited by Maryam11; 01-17-2017 at 02:51 AM.

+ 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. VBA Transfer Data From Excel to Word and Keep Bookmarks in Word Documents
    By ShakJames in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-08-2015, 05:37 AM
  2. Transfer Data between Excel and Word
    By s_samira_21 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-19-2015, 08:37 AM
  3. Replies: 0
    Last Post: 08-19-2014, 05:13 AM
  4. Data transfer from Excel to word
    By MrClaims in forum Word Formatting & General
    Replies: 1
    Last Post: 01-31-2014, 07:37 PM
  5. How to transfer data from Excel to Word
    By rohnds in forum Excel General
    Replies: 2
    Last Post: 01-11-2012, 07:26 AM
  6. Transfer EXCEL cells to WORD TEMPLATE
    By taimysho0 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 11-21-2011, 06:08 PM
  7. transfer of data from Excel to MS Word
    By amateur in forum Excel General
    Replies: 2
    Last Post: 02-03-2005, 03:06 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