Library not registered when early binding

S

Stuart Toll

I am trying to automate Excel 2000 from Word VBA. Late binding works ok, eg

Dim xl As Object
Set xl = CreateObject("Excel.Application")

However, I get an automation error - library not registered when I try to
use late binding (after adding a reference to the Microsoft Excel 9.0 Object
Library) and using the following code:

Dim xl As Excel.Application
Set xl = CreateObject("Excel.Application")

I have tried re-registering Excel9.olb, and reparing / reinstalling Office,
but to no avail. However, this does works ok on other PCs.

Any ideas as to how I can track down and solve this problem?
Thanks
Stuart
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top