Object Library feature not supported
 

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

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

Object Library feature not supported
 

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

Object Library feature not supported
 

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

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

Object Library feature not supported
 

It all sounds rather strange

Compile Error
Object library feature not supported

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

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

Object Library feature not supported
 

That works just fine, after fixing a couple of typos.

"Peter T" wrote:

It all sounds rather strange

Compile Error
Object library feature not supported

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

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

Object Library feature not supported
 

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

"Barb Reinhardt" wrote in message
...
That works just fine, after fixing a couple of typos.

"Peter T" wrote:

It all sounds rather strange

Compile Error
Object library feature not supported

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

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

Object Library feature not supported
 

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.