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

Biju
Keymaster
Post count: 220

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.