Need Help with Excel Export with Access 97
Posted on 2002-05-22
I am exporting a table to an excel spreadsheet.
i want to export it to a path that i am typing in at txtOpenFile
here is what i have so far
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel7, "qryContractsLbbExport", "LBB EXCEL EXPORT", True
i need to know where in the code to tell it to look at the path i have typed in in the txtOpenFile text box