Web Development

General discussion


Run-time Error '48' in VB6 using Excel11

By thomas.bihn ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Found the cause

by thomas.bihn In reply to Run-time Error '48' in VB ...

It was a bad Office installation by our IT guys. I found another PC with VB6 and Office XP Pro and Excel 2003 and it worked fine. They uninstalled the version on there and installed it fresh. Now it works.

Collapse -

Run-time Error '48' in VB6 using Excel11

by cris_garcia In reply to Run-time Error '48' in VB ...

Found also that a bad MSOffice Installation is responsible for this type of error.

Just reinstall thats it.

Collapse -


by jerith_alphonse In reply to Run-time Error '48' in VB ...

I have the same pblm.

Related Discussions

Related Forums