Skip to Content
0
Former Member
Nov 24, 2008 at 05:18 PM

query assignment in 3.5 workbook

25 Views

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 ??