Jul 20, 2015 Microsoft Office Forums Microsoft Word Word VBA: Extract Line of Text w/ specific characters up to the paragraph character, send to Excel User Name. There are about 1,000 instances of the text paragraph example. I need to extract the first line of each instance and send it to Excel so then I can import it into Access and build a query to.
I have a regular word document that includes a several furniture of information (name, dob, address, etc).
I feel wanting to possess a arranged up so when information is recently came into or changed within the word document it instantly filters through into my excel record. I understand this can end up being done using 'Exclusive Insert' but are wondering if it's achievable to do any other way. I know fundamental VBA as I can get the spreadsheet to open up and save from a switch within my Term doc. but that's it.
Any assistance is greatly welcome. long been fighting with this for a even though today. It might just be the corporation I am functioning for being old fashioned.
So to recap the word doctor can be the main hub of info and the excel doctor requirements to grab updated details from the word doc.
pnuts50.1k77 yellow metal badges6464 metallic badges102102 bronze badges
Ashley Niall CouttsAshley Niall Coutts
![Extract word in paragraph in vba pdf Extract word in paragraph in vba pdf](/uploads/1/2/5/7/125753187/466940991.png)
2 Answers
This is certainly more to my over comment. What this program code does is loops through each mobile in the desk line and extracts the text message which can end up being directly place into the Excel mobile thus negating the want to make use of
Copy-Paste
I have commented the program code so you shouldn't possess any issue understanding it. Nevertheless if you do then just post back.
You need to paste this code in a module and run it every period you need to move the Table information to Excel.
It goes unsaid that I haven't totally tested this code.
Siddharth RoutSiddharth Rout119k1414 yellow metal badges161161 metallic badges212212 bronze badges
I do that as soon as, here are the fundamentals, remorseful for the code can be in portuguese, but I'll remark it in english.The primary feature here is definitely the easyness to get table beliefs by their titles and brands.(there's no want for code translating)
Daniel MichaelöllerDaniel Möller41.1k88 platinum badges8686 magic badges118118 bronze badges