Posted 14 August 2019, 11:26 am EST
We are running into issues using the SaveExcel2007File() function in the last few months and was wondering if anybody else has had issues with this.
Below is the code snippet that has been working in production for the last 15 years and has recently not worked on some machines. We have done a lot of tests and checking and still have not figured out what is causing it to fail. We give the export function a log file, but it doesn’t create the log file. Is there anybody out there that has had issue with this export. It basically doesn’t create an excel file or a log file, it just returns from the call with a false.
if vaSpreadExcelExport.SaveExcel2007File(sFileNameSpread, “”, NoFormulas, sLogFile) <> True Then setReportMode True Screen.MousePointer = 0 DoEvents refreshCurrentReport MsgBox “Excel Workbook (xlsx) was NOT created.” & vbCrLf & vbCrLf & “See Log File (” & sLogFile & “)”, vbInformation, “Excel Export” Exit Function End If