HR, Payroll, Attendance Software › Forums › Lenvica HRMS › Ask a Question › Error: SaveAs method of Workbook class failed

Viewing 1 reply thread
  • Author
    Posts
    • Biju
      Keymaster
      August 25, 2015 at 06:59
      Post count: 220
      #19363

      Hi,

      I get this error with automated excel reports. I've scheduled excel reports to be emailed to multiple users. The scheduler history shows that the reports fail due to: Error: SaveAs method of Workbook class failed.

      How to solve this?

    • Biju
      Keymaster
      August 25, 2015 at 07:02
      Post count: 220
      #20182

      This is a know issue with Excel 2003/2007 and Windows 2008. Follow steps below to fix it:

      When using Windows 2008 server x64, create the following directory on the Lenvica HRMS Application Server to enable Excel importing and exporting:
      \Windows\SysWOW64\config\systemprofile\Desktop

      When using Windows 2008 server x86, create the following directory on the FDM Application Server(s) to enable Excel importing and exporting:
      \Windows\System32\config\systemprofile\Desktop

      Important:
      Lastly, bring up the Task Manager on Lenvica HRMS Application Server and end any hung Excel.exe processes.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.