1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
| '******************************
Sub exportinventory()
Dim TableName As String
Dim FileName As String
FileName = "H:\Daily report\2007\Inventory_Daily_Report"
TableName = "Inventory_data_daily_report_for_all_warehouse"
Call exportTableinv(TableName, FileName)
End Sub
'******************************
Sub exportTableinv(TableName As String, FileName As String)
Dim hui As Date
hui = Date
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, TableName, FileName, True, hui
End Sub
'****************************** |
Partager