+ Reply to Thread
Results 1 to 1 of 1

Macro to copy word to excel for beginner

  1. #1
    Registered User
    Join Date
    07-28-2017
    Location
    Spain
    MS-Off Ver
    14.0
    Posts
    1

    Macro to copy word to excel for beginner

    Hi, i am completely new on macro programming in excel, and i have a task to achieve. I want to copy a word document which follows a format into an excel document with other format.

    Actually, i am using Excel 2010 v14.0 as well as Word 2010.

    I have tried to look for the solution in this thread:
    http://www.excelforum.com/excel-prog...-possible.html

    But with my limited knowledge, i am not able to obtain the neccesary info needed for this task in there.

    This would be the original word document:

    Cap1.PNG

    Note that the number of B_text is variable between each table. The number of other X_text will always be 1 for each table. Also, tables may be splitted in different pages.

    We will not have any X_text in tables in the 'RANDOM STUFF' section.

    The result i would like to achieve is this:

    cap2.PNG

    As you can see, we would first have to look for the max_number of B in one table in the word document to determine the number of rows in the excel document.
    Note that all row headers in black will be predefined text, and we will not have to introduce nothing once they are set.

    Could someone help me achieve this?

    Thanks.
    Last edited by maiser; 07-28-2017 at 04:12 AM. Reason: added new relevant info

+ 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. Macro to Copy from Excel to Word
    By Beam_me_up in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-28-2008, 10:03 AM
  2. Macro to create copy of a .xls file (Beginner)
    By Yaz Patel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-11-2008, 10:30 AM
  3. [SOLVED] Copy from WORD to EXCEL using a macro.....
    By Tee in forum Excel General
    Replies: 1
    Last Post: 03-01-2006, 02:50 PM
  4. Macro to copy a word doc into an excel doc
    By Tee in forum Excel General
    Replies: 0
    Last Post: 02-22-2006, 08:10 AM
  5. copy from Excel to Word by macro with certain for
    By wmax77 in forum Excel General
    Replies: 0
    Last Post: 02-12-2006, 07:33 AM
  6. Macro to copy from Excel to Word
    By maperalia in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-21-2005, 07:05 PM
  7. [SOLVED] Macro for copy Word into Excel
    By emile in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-20-2005, 01:05 AM

Tags for this Thread

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