Object Library feature not supported
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
"Peter T" wrote:
do you have any other version of Excel installed
Regards,
Peter T
"Barb Reinhardt" wrote in message
...
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
"Peter T" wrote:
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
|