Find paragraph matching an expression in Word and exporting to Excel spreadsheet

		Microsoft Office Forums > Microsoft Word > Word VBA
Find paragraph matching an expression in Word and exporting to Excel spreadsheet

11-04-2017, 10:08 PM

gmayor

Windows 10 Find paragraph matching an expression in Word and exporting to Excel spreadsheet

Office 2016

Expert

Join Date: Aug 2014

Posts: 4,144

Paul's code anticipates a header row in the sheet with the word list

Code:

For i = 2 To xlShtIn.UsedRange.Cells.SpecialCells(xlCellTypeLastCell).Row

If you only have one word in your 'list' it will need to go in the second row of that sheet or there is nothing to search for.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet	Labyrinth	Word	7	07-19-2016 01:35 PM
Exporting quiz scores from powerpoint to excel spreadsheet/word	rjagile	PowerPoint	1	02-08-2016 02:26 PM
Find and replace in word document repeated for every item in excel spreadsheet	Daniell	Word	1	02-17-2015 04:38 AM
Trying to import specific data from one spreadsheet to another, without matching rows	Wynka	Excel	0	11-26-2014 09:33 AM
Macro: Exporting Data to a LEGIBLE Excel Spreadsheet	jeffcoleky	Word VBA	6	05-08-2012 08:24 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:19 AM.