Why did you do that? It's quite unnecessary.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi, have been trying to make this work on my mac but unfortunately without success. I've managed to connect to the file, but the sql-string seems te generate an error ("can't open data file" translated from dutch). I've simpified the sql from the tutorial above into

\s " SELECT [Subordinate Forename] FROM [Sheet1$] WHERE [Manager ID] = { MERGEFIELD Manager_ID } "

Still no luck. Please help.
test.docx

test.xlsx