Extracting text from Word doc to Excel.

New Contributor



I'm looking for a VBA script or formula that can open a word document and copy all the pages into an excel tab. Or possibly an VBA script that could open multiple word documents and copy each document into an individual tab. 


i.e -  1. Open Word doc "salesQ1" from my desktop.

2. Select everything (around 5 pages of text)

3. In the Excel ("sales by Q") workbook; create a new tab.

4.Copy selected information from Word doc to the new Excel Tab.


Any help would be much appreciated, thank you!


0 Replies