+ Reply to Thread
Results 1 to 6 of 6

Macros VBA for multiple word documents every first, fifth and tenth row copy into excel

  1. #1
    Registered User
    Join Date
    08-27-2012
    Location
    dubai
    MS-Off Ver
    Excel 2003
    Posts
    5

    Macros VBA for multiple word documents every first, fifth and tenth row copy into excel

    I need Macros VBA for multiple word documents (in the folder) required copy each first, fifth and tenth row into excel new file.

    Thanks.

  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: Macros VBA for multiple word documents every first, fifth and tenth row copy into exce

    Except for table cells, Word documents do not have rows. Please clarify your requirements, including:
    • what you want to copy;
    • what the destination is (e.g. a separate new workbook for each document; a separate new worksheet in the same workbook for each document; a separate worksheet for each 'row' (whatever that is), with each document's content split across the multiple worksheets, whether the data are to be arranged by columns or by rows, etc, etc).
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Registered User
    Join Date
    08-27-2012
    Location
    dubai
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Macros VBA for multiple word documents every first, fifth and tenth row copy into exce

    Every document have ref. no. date, company name and subject. I want to copy those only into new excel file for register purpose.

    Thanks lot.

  4. #4
    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: Macros VBA for multiple word documents every first, fifth and tenth row copy into exce

    Please Read my last post again. When you fully describe your requirements, I might be inclined to help. So far you haven't come close to doing so.

  5. #5
    Registered User
    Join Date
    08-27-2012
    Location
    dubai
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Macros VBA for multiple word documents every first, fifth and tenth row copy into exce

    I need Macros VBA for multiple word documents (in the folder) to Excel new file. Every documents has Ref. No. xxxxxxxx/3434/hr, Date: 12/12/14, company name: ABCD, Subject is Clarification. (not table).
    I needed in excel Every row has Column A1 – Ref. No. Column B1 – Date, Column C1 – Company Name, Column D1-Subject, etc for the next.

    Thanks.

  6. #6
    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: Macros VBA for multiple word documents every first, fifth and tenth row copy into exce

    You still haven't said how the document is structured, that is, where in the document these items are to be found. As I said at the outset, your reference to 'rows' in Word is meaningless unless those data are in a Word table.

    Perhaps the simplest way for you to answer this is to attach a document to a post with some representative data. You can do this via the paperclip symbol on the 'Go Advanced' tab.

+ 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. How do I copy and paste Word Documents into excel
    By Lylestyle89 in forum Excel General
    Replies: 2
    Last Post: 12-21-2013, 01:16 PM
  2. How to create multiple word documents using data from multiple excel files.
    By Milan Kotus in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-14-2013, 12:07 PM
  3. $$$ Macro to copy data from excel into word tables (example documents attached)
    By dapsef in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-04-2013, 12:17 PM
  4. VBA code to copy and create n number of word documents from excel range
    By skonduru in forum Word Programming / VBA / Macros
    Replies: 3
    Last Post: 01-17-2013, 03:20 PM
  5. Inserting multiple excel files into multiple word documents
    By lwaldron in forum Word Programming / VBA / Macros
    Replies: 11
    Last Post: 10-02-2012, 05:34 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