Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel range coding in DLL
I have couple of questions about VB6 COM addin
.. As quite newbee on this subject I create DLL ,reference it on Excel.But as most are being test DLL I'like to delete them rather than dereferencing. I do not know how to. .. Will I use the only file which has a extention "dll" if I want to use it on other PC as VB6 produce other files as well along with "dll" extentioned one? .. I put simple functions that I call from my excel code they work great. How can I make use of below excel VBA routine in my DLL. If Not Intersect(Target, Me.Range("C:C")) Is Nothing Then Call operatornamematch(Target) Target.Offset(, -2).Value = Worksheets("tr2007").Range("B2") Target.Offset(, -1).Value = Worksheets("tr2007").Range("B11") Target.Offset(, 3).Value = Target.Offset(, -2).Value & Target.Offset(, -1).Value & Target.Value Target.Offset(, 4).Value = Target.Offset(, -2).Value & Target.Offset(, -1).Value End if I use a wrapper to invoke DLL functions once Peter Beach suggested such as Option Explicit Private m_objMyThing As TestCOMDLL.TestClass Public Function TestWrapper1(ByVal a_nNumber as Double) As Double If m_objMyThing Is Nothing Then Set m_objMyThing = CreateObject("TestCOMDLL.TestClass") TestWrapper1 = m_objMyThing.DoubleIt(a_nNumber) End Function Thank you very much in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Color Coding cell based on date (over a large range) | New Users to Excel | |||
Range naming cells with blank cells through coding | Excel Discussion (Misc queries) | |||
VBA & Coding a dynamic range | Excel Programming | |||
optimize coding on named range | Excel Programming | |||
Implant macro coding into ASP coding | Excel Programming |