How are you referening the collection? Are you starting the indexing at
zero?


Usually I get all the queries on the worksheet using the following

for each qry in sheets("sheet1").queries
msgbox("Query Name : " & qry.name)
next qry


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=183104

Microsoft Office Help