OLEObjects

Aug 19, 2013 at 6:35 PM
I suppose it is not connected directly to this project but maybe someone can help me.
I'm trying create and add new COM object to the sheet. I've done this in C# (Shapes.AddOLEObject and OLEObjects().Add) but now I have to do this in C++ (ideally using this library).
Any hints?
Coordinator
Aug 19, 2013 at 7:01 PM
Why not just use VBA?
Aug 20, 2013 at 6:46 AM
What do you mean? Immerse VBA code in C++?
I'm trying to gather everything in one file. So far I have menu, functions and macros, all in C++. Next step would be adding custom activex to the sheet.
After that next challenge: adding ribbon tab. As I know I'd immerse C# in C++, so adding COM control seems to be much easier :)
Aug 20, 2013 at 9:02 AM
DONE!
ExcelX(xlcInsertObject, OPERX(_T("MyProject.MyControl")));

Thank you for excellent library!
Sep 20, 2013 at 12:30 PM
Now I've got ribbon menu support as well. Quite nice progress.
Next target: communication with activex control. At least setting properties, but two-way speaking is desirable.
Coordinator
Sep 20, 2013 at 10:29 PM
You should share your results. I'm sure a lot of people could benefit from this.
Sep 21, 2013 at 12:21 PM
I will (probably on our blog which not exists yet), but first I have to understand it and find a way to make it from the scratch (it was "weeks" try-and-error patching ATL project by hand).