My company recently moved to Office 365 and now I'm having issues using DoCmd.TransferSpreadsheet
This VBA used to transfer a query to a Worksheet and then open the Workbook
Now, the Workbook opens and then closes again. The transferred data if there, but I have to open the workbook using File Explorer or Excel.
Anyone know what could be giving this problem?
This VBA used to transfer a query to a Worksheet and then open the Workbook
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, WbSheet, CurrentProject.Path & "\" & WbName, True
Now, the Workbook opens and then closes again. The transferred data if there, but I have to open the workbook using File Explorer or Excel.
Anyone know what could be giving this problem?