HI i have a workbook1 which has query 1 in it.
there is lots of vbcode and other stuff which i dont wanna change
now i want to assign query2 in that workbook in place of Query1.
so that i still want the same workbook with all coding, graphs etc. for another query
and save this workbook as workbook2
in short want to get the replica of one workbook for several queries.
how to do that
if i do save as workbook1 to workbook2, how will i change the query assingment
any experts in 3.5 ??