Run Time Error - New Excel.Application

[tbassngal]

HELP! I just had my computer rebuilt and a database that did work is now not working. It is freezing up on the following code to open a new instance of Excel:

Set xlapplication - New Excel.Application

I get a run-time error 48, which is "error in loading dll"

I've loaded the complete access package onto the machine. Any ideas?

Thank you for your help in advance.

Tina Kimmer

 

[SkipVought]

Hi,

And you're running this code in...???

Have you set a reference to the Excel n.m Object Library, in the VB Editor?

Skip,
[sub]
[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine![/sub]

 

[tbassngal]

Okay, the version is Acccess 2000 on both machines however, the version on the computer that is working is (9.0.7616 SP-3) and the version on the machine that is not working is (9.0.3821 SR-1). I've checked my references and they are an exact match. I'm lost!

 

[SkipVought]

Again...

"Have you set a reference to the Excel n.m Object Library, in the VB Editor?"


Skip,
[sub]
[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine![/sub]

 

[tbassngal]

Yes - Excel 11.0 Object Library (we are office 2003) but still Access 2000 here.

 

[SkipVought]

Then I'd reload Office.

Skip,
[sub]
[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine![/sub]

 

[tbassngal]

Skip - I've already done that...

Thanks for your help anyway - please let me know if you can think of anything else.