Exporting two queries into separate sheets on one spreadsheet

[sam.eade]

Hi all,

At the moment i'm just using a simple DoCmd.OutputTo acOutputQuery to export two queries into separate spreadsheets but I need to merge them into the same document.

When I hit the button to run the code, it creates both files, so it's not exporting into an already existing sheet.

Ideally the first command would create the file like normal and the second query would just be input into another sheet on that file.

Can anyone help with the VBA needed to do this?

VBA skills beginner/intermediate.



Thanks

Sam

[June7]

Bing: access vba multiple queries one workbook

http://stackoverflow.com/questions/2...l-workbook-but

[sam.eade]

Bing: access vba multiple queries one workbook

http://stackoverflow.com/questions/2...l-workbook-but

Thankyou! Much appreciated.