U++ forum: Welcome to the forum

Re: OleCalc example can't compile [message #61540 is a reply to message #57424]

Wed, 12 March 2025 13:20

JeyCi
Messages: 69
Registered: July 2020

Member

Actually, it is compiled with MS_Build_Tools_2019 (for target Win32x), as described in docs in 2 steps, 5th point is important - "use .tlb" in calc.rc. Nevertheless, resulting OCX-file after regsvr32 ... .ocx and upload with Tools/Reference in Excel 2016 - is being instantiated just with early binding

Sub test()
Dim o As Object

Set o = New Calculator
o.Input = 5
End Sub

and is not instantiating Calculator_Window with Set o = Worksheets(1).OLEObjects.Add(ClassType:="Calculator").
Attempting to use compiled ActiveX as a Control at UserForm (added with View->Toolbox->Additional_Controls->Calculator Control 1.0) - is still being not drawn on UserForm.
Finally, with Developer->Insert ActiveX Control started to work.

Build-steps really helps.

I think, correct implementation of COM-dll gives very convenient advantage to use codes written in different languages together.
P.S. once will try Python as COM-Server or COM-Client coupled with UPP ...

Attachment: calc.zip
(Size: 1.92MB, Downloaded 102 times)

Best regards.

[Updated on: Wed, 12 March 2025 20:38]

Report message to a moderator