View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Object Library feature not supported


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


"Barb Reinhardt" wrote in message
...
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