Does anyone use Excel 2000? Please help me!

  • Thread starter Thread starter Shu
  • Start date Start date
S

Shu

Hi,
I have a urgent problem need to be solved soon.
I can not find the MS Outlook 9.0 object in the reference
list by default, so I use browse to select the related
file, then check it. It seems in this way the outlook
object can not be created.
I was given the error message: "ActiveX component can not
create an object" on the line 2:

Dim objOutlook As Outlook.Application
Set objOutlook = CreateObject("Outlook.Application")

Is there someone have the same experience to help me sort
it out? Thanks a lot.

Regards
Shu
 
If you can't find it in the reference list, then it probably isn't
registered properly. Maybe you can try reinstalling it. You may get a
better answer in an outlook group.
 
Thanks a lot, Tom. You are right, I tried the same code on
the computer at my office, it works.

Regards
Shu
 
You must log in or register to reply here.

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

Similar Threads

Sending emails with Outlook from Excel 2
Non Default Outlook Calendar 2
Closing Outlook VBE from Excel 1
Getting Excel to send message via Outlook 2000 2
Why Creating object failed even I set a reference to this object? 3
ActiveX component can't create an object 1
Emailing a Hyperlink of an Excel Workbook. 1
Can't open outlook from Access on Windows 7 64 bit PC 1

Back
Top