Hi all,
This is a similar concept to the topic of this thread. Only this time, instead of retrieving Properties and Methods of Objects, the code now retrieves the names and values of all the native ENUM constants contained in typelibs.
No extrenal libraries required. the functions in the code...
I have wrote a dll in visual studio. But when I try and add the .tlb file to the reference dialog box it tries to add it but doesn't show up. Also there isn't an error when I try and add the .tlb file. I'm unsure on what the problem is. The subs in the dll are also not able to be referenced...
I made a .DLL useing VB 2010 Express and want to call it in Excel VBA.
Here is my DLL code
PublicFunction MPSIDNum(ByVal LookupType AsLong, ByVal MPSValue AsString)
Dim oConnection As ADODB.Connection
Dim oRecordset As ADOR.Recordset
Dim FieldCol AsString
FieldCol = SetField(LookupType)...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.