A customer of mine uses Lotusscript and the Microsoft Excel object to create Excel spreadsheets with scheduled agents. The code is based on the normal way of creating spreadsheets – e.g.:

Set ExcelApp = CreateObject("Excel.Application")
Set ExcelWorkbook = ExcelApp.Workbooks.Open("C:test.xls")
Set ExcelWorksheet = ExcelWorkbook.Application.Workbooks(1).Worksheets(1)

The scheduled agents worked fine on a Windows Server 2003. The application was then installed on a freshly installed Domino server running on a freshly installed Windows Server 2008 x64 (64 bit) and then the scheduled agents started failing with the following error message: “SaveAs method of Workbook class failed“.

After several tries of fixing the code I finally found the simple (but unexpected) solution to the problem: create a folder called “Desktop” in C:\Windows\SysWOW64\config\systemprofile\.

Yes, that’s it! just create the folder and then the code starts working again 🙂