Command button exprt to excel

[cranebill]

I have a report that I run to view status multiple times a day, however this wastes alot of paper. Is there a way to hit a button that will export query results into excel and open there?

 

[PHV]

Have a look at the DoCmd.TransferSpreadsheet method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[cranebill]

so I tried it and this is what I have:

DoCmd.TransferSpreadsheet transfertype:=acImport, SpreadsheetType:=5, _
            tablename:="QA_STATUS_REPORT_FINAL", FileName:="SomeExcelFile", _
            Hasfieldnames:=False, Range:="test!A:F"

says field F1 does not exist...

any ideas?

 

[Spenney]

Is there a way to hit a button that will export query results into excel and open there?

DoCmd.TransferSpreadsheet transfertype:=[b]acImport[/b], SpreadsheetType:=5, _
            tablename:="QA_STATUS_REPORT_FINAL", FileName:="SomeExcelFile", _
            Hasfieldnames:=False, Range:="test!A:F"

Are you not trying to export to Excel?

Something like...

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, _
                    "qryYourQuery", "C:\Your Destination", True

 

[balin]

Why not just have a Button set to 'Print Preview' for your report.

I have all reports go to screen first for checking. Saves lots of paper,

jon