You could, of course, automate a hidden Excel session. Alternatively, you could use ADODB, which avoids the need for the code to interact with Excel at all. See posts 2 & 23 in: https://www.msofficeforums.com/word-...drop-down.html
You could, of course, automate a hidden Excel session. Alternatively, you could use ADODB, which avoids the need for the code to interact with Excel at all. See posts 2 & 23 in: https://www.msofficeforums.com/word-...drop-down.html
Cheers
Paul Edstein
[Fmr MS MVP - Word]
Posting Permissions
Reply With Quote