You need to change the Querytable objects' connection string and/or SQL
text. See:

http://www.dicks-clicks.com/excel/Ex...htm#ChangeConn
Jamie.

--