VB6 COM DLL Running in VBA Host
The buyer of this project required a solution that would provide an worked example of how to develop a COM DLL in VB6 that could expose a UDT (User Defined Type) so it could be called from a either a VB.Net or VBA application. The attached AVI shows the COM DLL being hosted and called from within Excel. Code Snippet Imports System.Runtime.InteropServices <ComClass(vbNet.ClassID, vbNet.InterfaceId, vbNet.EventsId)> _ Public Class vbNet Public Const ClassID As String = "28a0972a-33ee-4bbc-936a-de61f97c3eb3" Public Const InterfaceId As String = "26b10c2e-34e4-47b5-b75c-e7f17436e86f" Public Const EventsId As String = "d3a94af4-e5f2-460c-9461-8677fa8ff441" Public Sub New() MyBase.New() End Sub Public Sub Bark(ByVal vb6UDT As vb6COM.clsVB6COM) MsgBox("vb6UDT.TestString = '" & vb6UDT.TestString.ToString() & "'"
About Me
Many platforms and environments targeted in the production of robust solutions including, though not restricted to; Microsoft Office Automation (Access/Excel/Outlook/Word/Project) Power Bi Reporting & Analytics Windows client desktop application development .Net (C#/VB/ASP), VB6, ASP, BizTalk, Java SE & ME, C/C++ (ANSI/MS Visual/Borland) Microsoft Database Technologies SQL Server 7-2008, Access 97-2007 Embedded Systems Development Arduino/Esp32/STM32
$ 20 USD/hr
NEW FREELANCER!
