Hi,
I've created a dll in c# that works fine, but when I make changes and try to recompile, the dll is 'used by another process'. I use the dll in Excel by adding a reference in VBA to the .tlb file. My question is, is there a way to kill the process once I've used it? Sample code:
Sub test()
Dim x As ExcelDLL.TestExcelDLL
Set x = New ExcelDLL.TestExcelDLL
Range("b2").Value = x.Dummy(2)
End Sub
I've created a dll in c# that works fine, but when I make changes and try to recompile, the dll is 'used by another process'. I use the dll in Excel by adding a reference in VBA to the .tlb file. My question is, is there a way to kill the process once I've used it? Sample code:
Sub test()
Dim x As ExcelDLL.TestExcelDLL
Set x = New ExcelDLL.TestExcelDLL
Range("b2").Value = x.Dummy(2)
End Sub