Supporting various Excel versions

[yarivp]

I have an application that references Microsoft office 9.0, and I want it to support all versions of excel.
I can't use createObject because I need the events on it and I don't want to create several setups to each version.
Any suggestions ?

[lintz]

I use CreateObject to open and manipulate info within Excel without any problem as my users range from Excel 95 (sign) to Excel XP.

If you're unsure of a property add a reference to Microsoft office 9.0 then press F2 to open the Object Browser. (don't forget to remove the reference when you're done )

[yarivp]

The only problem with createObject is that it doesn't support events.
Do you have any solution for this problem ?

[lintz]

What type of events are you attempting?

[RobDog888]

I have an application that references Microsoft office 9.0, and I want it to
support all versions of excel.

I take it that it was a type o, but you do mean MS Excel 2000
correct? or are you programming against the Office commandbars or
something?

But as Lintz suggested, add the reference to create all the events and make
it easier to code the properties,etc. Then change it to CreateObject and
remove the reference.

HTH

[yarivp]

Thanks all but...
Since I can't define the 'o' object with event, than the events are not supported.
I want to use the OnChange event.
Well ?

[nareth]

try
Dim With Events Excel As Object
inside a form or class module

[yarivp]

You cannot use "withevents" while difning an object