Solved: Multiple queries output to one excel file

[boc_est1986]

I have seveveral queries being run that i would like to output to single excel file. I am currently using DoCmd.RunCommand acCmdOutputToExcel but this puts each one into a seperate workbook. I have also tried the TransferSpreadsheet method but because all my queries use a sepearte form to select a parameter this just isn't working. Does anyone know how i can achieve this?

[Norie]

Can't you use the same form for all the queries?

[HiTechCoach]

This may help: Export Data To Excel (http://www.hitechcoach.com/index.php?view=weblink&catid=84%3Aaccess-vba-office-automation&id=301%3Aexport-data-to-excel&option=com_weblinks&Itemid=23)

[boc_est1986]

This may help: Export Data To Excel (http://www.hitechcoach.com/index.php?view=weblink&catid=84%3Aaccess-vba-office-automation&id=301%3Aexport-data-to-excel&option=com_weblinks&Itemid=23)

Thanks this worked great

[HiTechCoach]

You're welcome.

Glad we could assist.