Use user's version of excel 2

[chicdog]

My problem is that in my program I export data to excel and the user has a different version than I do.

Run-time error '374':

Failed to activate control 'VB.UserControl'. This control may be incompatible with your application. Make sure you are using the version of the control that was provided with your application.

Is there a way to use the version of excel on a users PC or what do I need to do to fix it.

 

[JohnYingling]

In my production release, I was able to communicate with Word only by using Late Binding, that is, no Reference to Word Typelib, all Word Objects defined As Object{/b] and using
Set wrdObj = CreateObject("Word.Application").

See

http://support.microsoft.com/default.aspx?scid=kb;en-us;245115

Also search MSDN Knowledge Base on "Offie Automation Visual Basic 6".

http://www.VBResizer.com

Forms/Controls Resizing/Tabbing

http://www.VBCompare.com

Compare Code

http://www.VBSortGen.com

Generate Sort Class in VB

http://www.Vbcompare.com/Check.Htm(1979

Check To MS)

 

[Giordano]

I think I can give some direction(but I am not sure this is the resolution for your problem)

I helped somebody to resolve a problem to use Excell API.
The problem was that it worked with Excell XP but not with Excell 2000

I resolved it after I found out and copied the correct tlb and dll files from Excell 2000 to import into my c++ application(or add to references for VB code)...

After that the code ran with Excell 2000.

Hope it will help...

 

[chicdog]

Thanks John for pointing me in the right direction I believe that will work.