EXPORT QUERIES INTO EXCEL WORKBOOK AS WORKSHEETS 1

[netrusher]

I have six queries that I need to export into excel format. No problem. What I would really like to do from a macro or with code is export all six queries into one Excel Workbook with each query being it own worksheet by query name. Is this possible?

 

[danvlas]

Check the arguments of TransferSpreadsheet method. You may indicate the workbook and worksheet names.


HTH




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[DJN]

This will transfer the contents of the two queries to two worksheets in the one workbook.

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryYourQueryName1", "PathName.xls", True, "WorkSheetName1"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryYourQueryName2", "PathName.xls", True, "WorkSheetName2"

David

 

[netrusher]

David,

After I run this how can I then have the Excel File Open up?

 

[PHV]

You may try this:
DoEvents
Application.FollowHyperlink "PathName.xls"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886