Thanks for the input...I'm much closer. However, I am still getting an error message that the worksheet already exists. Does this mean that you cannot export to a worksheet that already exists? Please help me, I will try anything :)
Thanks again!
I am trying to export a couple queries to different worksheets in the same excel document. When I looked in Help, it said that you cannot specify a workbook when exporting to 2000. I know there has to be code to do this but I haven't had any luck yet. The data needs to be in Excel for a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.