Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.
Public Function ExportFormData() On Error GoTo ErrorHandler DoCmd.SetWarnings False Dim strDashboardPath As String Dim strQryVacRecords As String strDashboardPath = "\\teamspace\sites\RD_TEAM\ExcelExports\" strQryVacRecords = strDashboardPath & "VAC_RECORDS_2014.xlsx" DoCmd.TransferSpreadsheet TransferType:=acExport, SpreadsheetType:=acSpreadsheetTypeExcel12Xml, TableName:="QRY_VAC_RECORDS", Filename:=strQryVacRecords, HasFieldNames:=True DoCmd.SetWarnings True ErrorHandlerExit: Exit Function ErrorHandler: MsgBox "Error No: " & Err.Number _ & ";Description: " & Err.Description Resume ErrorHandlerExit End Function
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.