I have an application that generates statistical analysis of test data from production. It compiles the information then loads it into a preformated Excel spreadsheet to give a report for our customers and for internal quality control. I’ve verified this works on another current Microsoft OS (Windows Server 2003) which also has the Excel 2003 version.
When we go to pump the data into the sheet, we have:
DIM xlApp as Excel.Application
SET xlApp = New Excel.Application
When it encounters the set statement, we get an error “Run-time error ’48’. Unable to load dll.” The code hasn’t changed and has worked for a long time on other systems. An Microsoft Excel 11.0 Object is in the references.
Any suggestions? I have searched and searched but am having a difficult time finding anything indicating why this problem now.
Thanks in advance.
