I developed an OLE mini server using VC++6. Everything works fine (both release and debug) as long as I insert the object manualy through the Insert Object dialog of MS Excel 2000. When I've tried to insert it from a VB AddIn for Excel it draws the frame but the interior of the rectangle remains transparent (the object is created but the container image of it isn't updated). It seems that when I insert from VB the OnGetExtent event it is not triggered (in the manualy case it is). How can I fix it? (I'll try to trigger the OnGetExtent through a method exposed by my object.) Here is a sample of how I try to insert the object from VB: Dim obj as OLEObject set obj = XLInstance.Sheets(ActiveSheet.Name).OLEObjects.Add (ClassType:="MyChart.Chart") X| :confused: Thanx in advance...

I developed an OLE mini server using VC++6. Everything works fine (both release and debug) as long as I insert the object manualy through the Insert Object dialog of MS Excel 2000. When I've tried to insert it from a VB AddIn for Excel it draws the frame but the interior of the rectangle remains transparent (the object is created but the container image of it isn't updated). It seems that when I insert from VB the OnGetExtent event it is not triggered (in the manualy case it is). How can I fix it? (I'll try to trigger the OnGetExtent through a method exposed by my object.) Here is a sample of how I try to insert the object from VB: Dim obj as OLEObject set obj = XLInstance.Sheets(ActiveSheet.Name).OLEObjects.Add (ClassType:="MyChart.Chart") X| :confused: Thanx in advance...

I'm a VB coder and I found a lot of good stuff here. The main problem is to be able to understand the code exposed. btw - I didn't know till I red your message that the foolish could be so painfull...

I'm completely new to ATL:omg:. I use VB.:mad: I know C++ && API. I have next questions: 1.How do I define and raise an event from a class defined inside atl.:confused: 2.How do I raise errors to the clients that use my DLL.:confused: I'd appreciate if you give me some MSDN refferences or even articles inside CodeProject. - Any suggestions how to make subclassing for a window through the pass of hWnd parameter inside an ATL DLL? (I have some ideas that worked well under vb using API functions but I really appreciate the experience of the coders that visit this site, so I expect your opinion.) - I want to use ATL to build an DLL that takes as parameter the hWnd and subclass certain messages secified through an AttachMessage method. When the message is received I want to raise an event WndProc(...) into the caller.:confused: Thanx to all of you.:rose: I have a lot to learn from you. Cosmin Amza

Here is a resultset: ID Name Value --------------------------------- 101 Name1 Value1 101 Name2 Value2 101 Name3 Value3 101 Name4 Value4 101 Name5 Value5 101 Name6 Value6 Could anyone tell me a way that could transform the above resultset in something like next one? (I'd prefer an SQL approach / not cursors and so on... but i appreciate them anyway). Name1 Name2 Name3 Name4 Name5 Name6 ---------------------------------------------- Value1 Value2 Value3 Value4 Value5 Value6 Is there any solution that don't use OLAP or extended procedures? ThanX, :confused: In MSAccess things are simple (see Crosstab query) - but in SQL Server 7 I don't know how to do it.

Here is a resultset: ID Name Value --------------------------------- 101 Name1 Value1 101 Name2 Value2 101 Name3 Value3 101 Name4 Value4 101 Name5 Value5 101 Name6 Value6 could anyoane tell me a way that could transform the above resultset in something like next one? (I'd prefer an SQL approach / not cursors and so on... but i appreciate them anyway) Name1 Name2 Name3 Name4 Name5 Name6 ---------------------------------------------- Value1 Value2 Value3 Value4 Value5 Value6 ThanX, :confused: In MSAccess things are simple but in SQL Server 7 I don't know how to do it.