Turn on the macro recorder and then manually connect to that connection. That should get you the syntax (more or less).
Regards, Jan Karel Pieterse Excel MVP jkp-ads.com
Forum Rules