Export multiple queries into a single spreadsheet in different range of cells

[riaarora]

Dear All,



I need to export multiple queries into a single spreadsheet in different range of cells. Means one query need to be exported from B2:E2 and second query need to be exported from B10:E10. In this way need to export 18 queries' result into one sheet only on different name range.

If anyone has sample VBA code then please help to post it.

Any help would be appreciated. I am using Access 2007 and need to export data into Excel 2003 format.


Thanks a lot for the help.

Regards
Ria

[June7]

Review http://forums.aspfree.com/microsoft-...el-413629.html

[riaarora]

Thanks for the quick respone. I want to export the data in a particular cell range e.g. 1st query should export the data from Cell B1 to D7. And 2nd query from B10 to D15 and so on. I have total 13 queries which need to be exported into same sheet in different range cell.

[alansidman]

See my response at this cross posting

http://www.access-programmers.co.uk/...33#post1162633

Alan

[June7]

The link I referenced has example code for exporting data to specific cells of designated sheet in workbook. That and the references by Alan should give enough guidance to attempt code for your circumstances. Make attempt and post for analysis if you encounter specific issue.