Adaytay
03-29-2011, 09:39 AM
Hi everyone... wow, it's been a while!
A bit of an issue has been reported to me by one of our authors here. We have a list of circa 20,000 tags which he has dumped into Word to run a spellcheck, which he's then highlighted each row that contains a spelling error. And now he wants to filter out the highlighted rows only.
I would like to write a bit of code to cycle through each row in a table, and, if the row is highlighted yellow, to put an entry into the first column (which is currently blank). I'm thinking then drop this into Excel and filter that way.
We've tried saving as pretty much every single format but each method looses the highlighting when we open it up into Word.
Data is in the second and third column and it is this that will be highlighted.
I'm a bit rusty when it comes to word stuff... is there a quick way to do this?
Many thanks in advance,
Adam
A bit of an issue has been reported to me by one of our authors here. We have a list of circa 20,000 tags which he has dumped into Word to run a spellcheck, which he's then highlighted each row that contains a spelling error. And now he wants to filter out the highlighted rows only.
I would like to write a bit of code to cycle through each row in a table, and, if the row is highlighted yellow, to put an entry into the first column (which is currently blank). I'm thinking then drop this into Excel and filter that way.
We've tried saving as pretty much every single format but each method looses the highlighting when we open it up into Word.
Data is in the second and third column and it is this that will be highlighted.
I'm a bit rusty when it comes to word stuff... is there a quick way to do this?
Many thanks in advance,
Adam