Search results
-
S
Solved How to export Excel file to wanted directory?
My supervisor asked me that whether an access table can be exported to their wanted directory. Currently, I am using outputFileName = CurrentProject.Path & "\Report002_" & tb_Year.Value & cmb_Quarter.Value & ".xls" DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9...- sharonng
- Thread
- Replies: 18
- Forum: Modules & VBA
-
S
Cannot export file using DoCmd.TransferSpreadsheet
Hello, I have encountered a problem when trying to export an xls file in Access VBA. My code is as follows: Private Sub btn_exportnormal_Click() Dim outputFileName As String Dim nrange1, nrange2 As Integer If tb_Year <> "" And cmb_Quarter <> "" Then Select Case...- sharonng
- Thread
- Replies: 3
- Forum: Modules & VBA