Object Library feature not supported

  • Thread starter Thread starter Barb Reinhardt
  • Start date Start date
B

Barb Reinhardt

I'm using this code out of Outlook
Dim XLApp as Excel.Application

Set XLApp = CreateObject("Excel.Application")

And it's worked before, but today I'm getting the following error:

Compile Error
Object library feature not supported

I have chosen the Microsoft Excel 12.0 Object Library in the References
within the VBE. Does anyone have any idea why this might not work.

Thanks,
Barb Reinhardt
 
Try,

Dim XLApp as Object ' Excel.Application
Set XLApp = CreateObject("Excel.Application")

If that works, do you have any other version of Excel installed

Regards,
Peter T
 
It worked once I changed all of the
Dim abc as Excel.Something to
Dim abc as Object

It used to work. Any idea why I had to change it to late binding?

Thanks,
Barb Reinhardt
 
I have a folder for Office11 on my machine, but don't see any application for
that version. This may have started when I moved to a new machine that has
Excel 2007 on it.

Thanks for your assistance.
Barb Reinhardt
 
It all sounds rather strange

Start a new project, say in a Word doc. Add the reference to Excel 2007,
write a simple routine that refers to Excel, eg

Sub test()
Dim xlApp as Excel.Application
Dim rng As Excel.Range
dim ws as Excel.Worksheet
dim wb as Excel.workbook

set xlApp = CreateObject("excel.application")
xlApp.visible = true
set wb = xlApp.workbooks.add
set ws = xlApp.ActiveSheet
set rng = xlApp.ActiveCell
wb.close fale
xlapp.quit
end sub

might be a typo or two!

Compile the project and try the test routine

Regards,
Peter T
 
OK, in the code that doesn't compile do you see anything relating to the
Excel object model that was introduced in '2007.

Regards,
Peter T
 
I deselected an Office 11.0 reference (and now I can't find it again) and
everything ran fine. I don't know why the reference was selected in the
first place. Thanks again for your help.
 
Back
Top