View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.programming
Chris Chris is offline
external usenet poster
 
Posts: 788
Default Can Excel show OLE object created in DLL of VB6 ?

The test includes 2 types of objects. One is the OLE Container Control and
the other is an object I added from VB6 (PROJECT/COMPONENTS/Insertable
Objects/Microsoft Excel Chart) and code below is used

Set chrt = Chart1.object.Charts(1)
Set exl_WKS = Chart1.object.Worksheets(1)

All code is in DLL. In Excel & Power Point VBA, I reference the DLL and just
calling form from DLL.