I have been transferring query results for the past year using the transfer spreadsheet routine. I have written a new one for a new query and all of a sudden it wont let me transfer the data saying that the destination folder is not available or already open! Not true. I even simplified the destination to my desktop on my laptop to see if that solved it but to no avail. the code is this;
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryProdRprt", "C:\Users\StevieB\Desktop"
DoCmd.OutputTo acOutputReport, "rptShiftRptNow", acFormatPDF, "C:\Users\StevieB\Desktop"
it stops at the transfer spreadsheet line saying it cannot write to the file "C:\Users\StevieB\Desktop" it is already opened exclusively by another user, or I need permission to view and write it's data.
Any help as always is much appreciated.