In the Win 7/VS2015/Excel 2013 environment everything works fine, but under after transferring and compiling under Win 10/ VS2019 the Excel 365 VBA code errors at the line:- Set x = New TestLib.C_HelloĬan anyone tell me what I have to do to get this working in the Windows 10 / VS2019 / Excel 365 environment. Where TestLib is the C# COM module created in Visual Studio. The Excel 2013 VBA code is equally simple: Sub Test() In the Assembly Info I have ticked the checkbox " Make the Assembly COM Visible" and in the Build info I have ticked the checkbox " Register for COM interop" Using Win 7/Visual Studio 2015 the following very simple code compiles as a C# class library and creates a COM object that I can call successfully from Excel 2013 VBA:- using Step 4 In the right list, click ClassLibrary Step 5 Change the Name to SampleLibrary and click OK Step 6 Click OK.
Step 3 In the left list, click Windows under Visual C.
I wish to create a C# COM object which I can call from Excel(365) VBA code. Step 1 Start Microsoft Visual Studio Step 2 On the Menu Bar, click File -> New Project. I have upgraded from Windows 7/Visual Studio 2015 to Windows10/Visual Studio 2019.
0 kommentar(er)
