SaveExcel2007File Isssue

Posted by: FromGrapeCity on 14 August 2019, 11:26 am EST

  • 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
  • Marked as Answer

    Replied 18 August 2019, 9:54 pm EST

    Hi,

    This has been answered in SupportOne case, 394211 (you posted).
    Please continue the thread over there.

    Thanks.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels