Access Report To Excell

[access2010]

I would like to help an agency that I volunteer at to export from within MsAccess 2003 a reports as a Excel file.

The MsAccess report name is - Cheque_Issued_But_Not_ReconciledR
The excel file will be saved as - C:\Bank\Cheque_Issued_But_Not_Reconciled.xls

If possible, can the saved excel file be saved as (Today Monddyy_FileName) C:\Bank\Feb1311_Cheque_Issued_But_Not_Reconciled.xls

We thank you for your help.

 

[access2010]

Report as a Excel File

I would like to help an agency that I volunteer at to export from within MsAccess 2003 a reports as a Excel file.

The MsAccess report name is - Cheque_Issued_But_Not_ReconciledR
The excel file will be saved as - C:\Bank\Cheque_Issued_But_Not_Reconciled.xls

If possible, can the saved excel file be saved as (Today Monddyy_FileName) C:\Bank\Feb1311_Cheque_Issued_But_Not_Reconciled.xls

We thank you for your help.

 

[smig]

you should export the report's query, not the report

 

[MStef]

I suggest to send a query in Excel.
Look at "DemoQrytoExcelPahtA2000.mdb" (attachment, zip).
Open form and try.

 

[SpentGeezer]

Re: Report as a Excel File

Greetings,

This will get you started...

Dim strFilePath as string
strFilePath replace(NOW," ","")
strFilePath replace(strFilePath,":","")
strFilePath replace(strFilePath,"/","")
strfilepath = "c:\Bank\" & strfilepath & "_Cheque_Issued_But_Not_Reconciled.xls
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Cheque_Issued_But_Not_ReconciledR", strfilepath, True

 

[access2010]

Re: Report as a Excel File

Thank you for your suggestion, but an other forum member has sent me a .Mdb file that we have addapted to our needs.

 

[access2010]

Thank you for your file which we have adapted to our needs.