Hi.
I want to export my report to an excel file exactly the same as the inbuilt method, but with a fixed path to save it...is this possible??
Code currently using...
stDocName = "saveReportFormat"
DoCmd.OutputTo acReport, stDocName
is there a way i can do this, but not have the save window pop up and have a hard coded file path??
also i dont want to use...
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, reportName, theFilePath, True
because this removes all formatting and only works on query's...unless there is a way to manipulate this code to save reports to file instead of queries?
thanks in advance