Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Use user's version of excel 2

Status
Not open for further replies.

chicdog

Programmer
Feb 28, 2002
84
US
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.
 
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
Also search MSDN Knowledge Base on "Offie Automation Visual Basic 6".

Forms/Controls Resizing/Tabbing
Compare Code
Generate Sort Class in VB
Check To MS)
 
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...
 
Thanks John for pointing me in the right direction I believe that will work.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top