+ Reply to Thread
Results 1 to 1 of 1

VBA Coding to transfer data from Word Form to Excel

  1. #1
    Registered User
    Join Date
    10-12-2016
    Location
    Staffordshire
    MS-Off Ver
    2016
    Posts
    1

    VBA Coding to transfer data from Word Form to Excel

    Hi - apologies if this has already been dealt with elsewhere but I'm new and desperate! I have created a word form for use with my clients - attached (I'm a Careers Adviser). I need to have the information from some parts of the form copied over to the spreadsheet attached. I've highlighted the data needed in yellow. I'd like to be able to do this automatically every time I click on a button in the document or close it down. How do I do this? I've read it's VBA code but no idea where to start! I'm also trying to add an auto save button so the document is saved to a pre-defined location. Everything will be done on one computer so I'm not sharing it across a network or anything like that. THANKS!
    Attached Files Attached Files

+ 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. Replies: 2
    Last Post: 12-29-2015, 06:35 AM
  2. 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
  3. Script to transfer from MS Word form to EXCEL
    By walshth in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-15-2014, 12:31 AM
  4. Using VBA to transfer data from Excel form to a web form. error 'Permission Denied'
    By danieldowds in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-14-2014, 08:14 AM
  5. Transfer data from excel form to word document
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-08-2011, 03:05 AM
  6. [SOLVED] How to Transfer data from Text Form Fields in MS Word into Excel?
    By CWillis in forum Excel General
    Replies: 1
    Last Post: 07-18-2006, 01:35 AM
  7. Transfer data to form from Excel range upon loading of form.
    By Rob Crawford in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-24-2005, 11:05 AM

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