Run-time error '3044'

[niacin]

Hi,



When I run the following code I get a Run-time error '3044':

Private Sub Command0_Click()
DoCmd.SetWarnings False
DoCmd.OpenQuery "qry_cost_01_update_month", acViewNormal, acEdit
DoCmd.OpenQuery "qry_cost_02_update_WL_categories", acViewNormal, acEdit
DoCmd.OpenQuery "qry_cost_03_update_wouldbe_W_category", acViewNormal, acEdit
DoCmd.OpenQuery "qry_cost_04_update_invoice_W_category", acViewNormal, acEdit
DoCmd.OpenQuery "qry_cost_05_wouldbe_cost", acViewNormal, acEdit
DoCmd.Close acQuery, "qry_cost_05_wouldbe_cost"
DoCmd.OpenQuery "qry_cost_06_invoice_cost", acViewNormal, acEdit
DoCmd.Close acQuery, "qry_cost_06_invoice_cost"
DoCmd.OpenQuery "qry_cost_07_update_savings_master", acViewNormal, acEdit
DoCmd.OpenQuery "qry_cost_08_breanne_report", acViewNormal, acEdit
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qry_cost_08_breanne_report", "U:\Logistics Savings\Savings", True
DoCmd.SetWarnings True
End Sub

In the debugger, the bolded line is highlighted. "Logistics Savings" is a folder in my U Drive. If I make the path "U:\Logistics Savings" the spreadsheet exports directly to my U Drive with the name "Logistics Savings.xls". I need to export the spreadsheet to my U Drive, Logistics Savings folder, and name the spreadsheet "Savings.xls".

[Jester0001]

Does it save correctly if you substitute ".xls" or ".xlsx" at the end of the file path? Like this:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qry_cost_08_breanne_report", "U:\Logistics Savings\Savings.xls", True

or

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qry_cost_08_breanne_report", "U:\Logistics Savings\Savings.xlsx", True

[niacin]

Negative, if I put .xls or .xlsx, it still does not save correctly.

[Jester0001]

I know this sounds simple, but double-check to ensure that there is a folder on your U:\ drive called "U:\Logistics Savings". Be sure the the spelling is 100% correct, along with a space between 'Logistics' and 'Savings' in the folder name.

I tried your code (using Win7 and Access 2010) using my C:\ drive, and it worked (see image). I'm not too sure about external or networked drives.