+ Reply to Thread
Results 1 to 2 of 2

VBA Copy certain data from Word to Excel

  1. #1
    Registered User
    Join Date
    06-09-2016
    Location
    England
    MS-Off Ver
    2013
    Posts
    2

    VBA Copy certain data from Word to Excel

    I need to complete one task in VBA and after looking on the INTERNET for the past months, I think I'm too noob to make it.
    I have a word file - standard INDEX file. I need to copy the data from this file to another (excel) based on some logic:

    Logic:
    dps_so - DPS number (In INDEX: Header DPS ....)
    pnm - Number of the package (In INDEX Header (EX): Doccument NO. PNM34810305)
    std_bal - package number (In INDEX: ATD Package B001)
    cislo_rev_bal - Revision (Usually is 00)
    datum_rev_bal - Date - manually puted
    nazov_dok_sk_en - Informations (In INDEX: Title)
    cislo_dok - Number (Will be the number from the Title - In INDEX: PAR)

    The problem which I really don't understand, is that I need to know first how many lines the word file has!?

    As you can see, I have completed the starting as an example (copy/paste).
    Some discussion are to make bookmarks in word file and use them.
    Some other forums are just making copy/paste for the hole word file to sheet.

    Any idea will be good. Thank you for your time.

    QzN3v.png
    pLyWw.png

  2. #2
    Registered User
    Join Date
    06-09-2016
    Location
    England
    MS-Off Ver
    2013
    Posts
    2

    Re: VBA Copy certain data from Word to Excel

    I don't think that nobody knows about this, therefore, I think that I've made a mistake exposing my problem!?
    Please, any idea, or' even a link to some info regarding this task, will be very appreciated.

    Thank you.
    Daniel

+ 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. pls help me in copy data from excel to word
    By speedmax in forum Word Programming / VBA / Macros
    Replies: 7
    Last Post: 04-25-2013, 06:21 PM
  2. 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
  3. Copy word data into Excel row
    By condor07 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-09-2010, 09:58 AM
  4. Copy excel data to word?
    By Kusenbusen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-11-2009, 09:22 AM
  5. How to Copy My MS Excel Data In MS Word?
    By techin in forum Word Formatting & General
    Replies: 1
    Last Post: 08-18-2009, 08:22 PM
  6. Copy data from word to Excel
    By djfatboyfats in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-22-2008, 07:26 AM
  7. copy data from excel to word
    By benhiggi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-07-2008, 01:19 PM
  8. Copy or Insert Excel Data to Word
    By tkelsey in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-03-2005, 06:58 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