COM Interop without regasm

.net vba outlook com-interop limited-user
SLaks picture SLaks · Aug 30, 2009 · Viewed 8.6k times · Source

I'm a limited user, and I need to write an Outlook macro that exposes a C# library in Outlook 2003 and 2007.

I do not have any admin privilges at all, not even at install time, so I can't run RegAsm and I can't (I assume) write a managed add-in.

Is there any way to call .Net code from VBA in this scenario, or are there any other solutions?

This is for personal use only, so an ugly hack is perfectly acceptable (so long as it works)

Answer

SLaks picture SLaks · Oct 23, 2009

I solved this by running regasm with the /regfile option, and replacing HKLM with HKCU in the resulting .reg file.

Related questions

How to count the number of rows in excel with data?

column A has data like this (ie frequent blank cells): HEADING <-- this is A1 kfdsl fdjgnm fdkj gdfkj 4353 fdjk <-- this is A9 I would like to be able to get the cell reference of the last …

Read More
How to call .NET methods from Excel VBA?

I found a way to call .NET 2 code directly from VBA code: Dim clr As mscoree.CorRuntimeHost Set clr = New mscoree.CorRuntimeHost clr.Start Dim domain As mscorlib.AppDomain clr.GetDefaultDomain domain Dim myInstanceOfDotNetClass As Object Set myInstanceOfDotNetClass = domain.CreateInstanceFrom("…

Read More
Can't instantiate a COM object written in C# from VBA (VB6 ok)

Using VS 2008, here is my COM object using System; using System.Collections.Generic; using System.Text; using System.Runtime.InteropServices; using System.Windows.Forms; namespace TestCom { [Guid("9E5E5FB2-219D-4ee7-AB27-E4DBED8E123E")] [ClassInterface(ClassInterfaceType.…

Read More