Results 1 to 5 of 5

How to use excel VBA to open word doc and copy ENTIRE word document and paste into excel

Threaded View

welchs101 How to use excel VBA to open... 07-26-2020, 03:22 PM
welchs101 Re: Macro to get data from a... 07-26-2020, 09:30 PM
welchs101 Re: Macro to get data from a... 07-26-2020, 09:51 PM
welchs101 Re: How to use excel VBA to... 07-27-2020, 10:07 AM
welchs101 Re: How to use excel VBA to... 07-27-2020, 10:57 AM
  1. #1
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2016
    Posts
    2,712

    How to use excel VBA to open word doc and copy ENTIRE word document and paste into excel

    i am enclosing two files. One and excel file and two a word file.

    My scenario is this.........i have a word file that has in it parts of a job application.I want to copy those parts highlighted in yellow from word to excel and paste into the appropriate columns in excel.

    I found some code online that opens the word file.............but then it locks up my excel so i commented that part out.

    I tried to find excel vba code that references how to move around in the word document buti cant find anything. I even tried "recording" macros inside word itself and this did not help. Maybe i was doing it wrong.

    If you can help i would appreciate it. if you know of any good articles or if you can provide some code to show me how to do it....that would help. thanks.
    Attached Files Attached Files
    Last edited by welchs101; 07-27-2020 at 10:05 AM. Reason: change title/ focus of post

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to copy/paste picture of table in Excel worksheet into a Word document
    By grbears in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-25-2017, 11:25 AM
  2. Mail merge of Excel data to Excel document, not using a Word document
    By Howie D in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-23-2015, 07:35 AM
  3. Replies: 0
    Last Post: 09-04-2014, 03:32 AM
  4. Macro to send excel data to a word document, possible?
    By Butcher1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-21-2013, 11:43 AM
  5. copy data from excel and paste the data to word document in speciofic column.
    By vsabap in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-17-2012, 07:12 AM
  6. Copy data from Excel and paste it in a table in word document
    By shekhar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-04-2012, 05:28 AM
  7. Replies: 1
    Last Post: 10-17-2005, 04: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