Ronald Malk
asked on
Excess tables to Excel BackUp
I have this code below I know is poorly added up but still working creating back up for six tables in Six sheets in one Excel file but it gets created only in my documents folder, what I need is to direct the back up to a folder on the desktop and if possible maybe some reshape to the code because as you see in my code I'm naming the destination file with every table is this OK ? (I'm using 2010 office)
Dim OutputFileName As String
OutputFileName = "C:\Users\Orly\Desktop\bac kups"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xm l, "Tbl_Stock_Main", Format(Now, "yyyyMMdd hh mm"), True
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xm l, "Tbl_Stock_Orders", Format(Now, "yyyyMMdd hh mm"), True
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xm l, "Tbl_Stock_Prchs", Format(Now, "yyyyMMdd hh mm"), True
Dim OutputFileName As String
OutputFileName = "C:\Users\Orly\Desktop\bac
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xm
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xm
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That was quick, It' s working good, Thanks mate, Thank you so much
or
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xm