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 report, so any suggestions on how to get it there would be greatly appreciated.
Thanks in advance!
Thanks in advance!