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
Bookmarks