Strange problem...

[Glutus]

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

 

[SkipVought]

Hi,

Sub test()
   Dim x As ExcelDLL.TestExcelDLL
   Set x = New ExcelDLL.TestExcelDLL
   Range("b2").Value = x.Dummy(2)

  Set x = Nothing
End Sub

Skip,
[sub]
[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?" [/sub]

 

[Glutus]

WOW, I knew it was simple. It works fine. Thx