View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Cannot insert object when I update version

Nothing in the KB on the lastest version, but for Office 97, there were some
restrictions.

http://support.microsoft.com/default...&Product=ofw97
XL97: Error Inserting ActiveX Object in a Worksheet

http://support.microsoft.com/default...&Product=ofw97
OFF: .Exd Files Are Created When You Insert Controls


another possibility:

http://support.microsoft.com/default...80&Product=ofd
PRB: Error Message "Cannot insert object" in Excel

--
Regards,
Tom Ogilvy


"DogMan" wrote in message
...
I have an ActiveX control that I developed with ATL that I recently

enhanced. I updated the type library version from 1.6 to 1.7.

The new control works fine with Visual Basic and Internet Explorer.

However when I try to load it into Excel I get the message "Cannot insert
object".

I assumed the problem was a mismatch between the version of the type

library and a version specified in the header for the control. However
synchronizing them did not help.

Someone on the vc.atl board suggested that Excel might be caching the old

type library. How can I check this? Does anyone have any other ideas what
might be causing this problem?