We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Public Function ExportFormData() On Error GoTo ErrorHandler Dim strDashboardPath As String Dim strQryEmployees As String strDashboardPath = "\\teamspace\DavWWWRoot\sites\CCCoaching\" strQryEmployees = strDashboardPath & "QRY_EMPLOYEES_UUS.xlsx" DoCmd.TransferSpreadsheet TransferType:=acExport, SpreadsheetType:=acSpreadsheetTypeExcel12, TableName:="QRY_EMPLOYEES", Filename:=strQryEmployees, HasFieldNames:=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.
|Match two excel worksheets based on common columns||4||34|
|Combining Multiple Access Reports that Have Different Criteria Sources||1||21|
|Access 2010 Changing String to Date with Leading Zero||11||32|
|VBA - How to copy the data from workbook to workbook masterfile in VBA?||20||50|
Join the community of 500,000 technology professionals and ask your questions.