You could use ADODB to read the worksheet, which would be faster, but it wouldn't be any simpler. What you are asking for is complex.
You might find http://gregmaxey.com/word_tip_pages/...functions.html useful.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
|