Timeline for How to call a DLL file from VBA?
Current License: CC BY-SA 3.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 13, 2011 at 6:50 | history | bounty ended | CommunityBot | ||
| Oct 6, 2011 at 22:29 | comment | added | Mike T | It's a pity that the author did not expose any public functions in the COM interface. If the author did this, then you'd be able to programmatically use the functionality of this module in VBA (or other environments that use COM) | |
| Oct 5, 2011 at 20:05 | comment | added | Petr Krebs | It does implement ICommand, but you cannot see its methods in the Object Browser because ICommand is not the default interface. VB Object Browser shows only members of the class' default interface, which is generated automatically for libraries written in VB and in this case this default interface has no members. Anyway, you can only execute the command and that's just about it. You have no way to alter the original code behavior to suit your needs. | |
| Oct 5, 2011 at 19:49 | comment | added | Demetris | Thanks Mike. I tested successfully what are you saying. So, the conlcusion is that the certain DLL is not usefull for what I aim to do. It is may be better to readdress my question. Ragi:I want to do that because it fits exactly to my needs, especially it capability for defining a polygon layer used as the external boundary of the Thiessen polygons area. Blash238:The first posting in that link says that it has a DLL to create Thiessen polygons and looks for the source code, that is, what I am looking for. | |
| Oct 5, 2011 at 19:27 | comment | added | Mike T | @Demetris: you need to add a reference before you can browse the object. I've added some additional screen captions so you can see how to add it. Note: I re-evaluated this with ArcInfo 9.3 with same results. | |
| Oct 5, 2011 at 19:25 | history | edited | Mike T | CC BY-SA 3.0 |
add more screenshots, and elaborate answer
|
| Oct 5, 2011 at 17:08 | comment | added | blah238 | @Demetris nothing in the code in the linked thread references a DLL, it's all ArcObjects. Can you not use the function they provided instead of the DLL? | |
| Oct 5, 2011 at 16:29 | comment | added | Ragi Yaser Burhum | Mike's answer is correct. The ESRI object browser will only show you objects that are registered in the right component category (did it come with a separate reg file???)Kirk's remark is very valid, too. You could be dealing with a pre-9 dll and it would not work since the object libraries got refactored for 9.0 My question to you is why are you trying to do this. If it is to create Thiessen polygons, this equivalent to driving from LA to Vegas, with a minor bathroom stop in Taiwan. | |
| Oct 5, 2011 at 15:49 | comment | added | Demetris | Mike, thanks for the effort. However, it is still not clear the scene for me.Why I cannot find the clsThPoly in ESRI Object Browser? I cannot also find the Tools>Refernces in EXCEL or something similar in ArcGIS;and the conclusion is that I can use it or not? I found in this link forums.esri.com/… a function that it is supposed it runs the ThiessenPoly.DLL as I understood. As you may see above I note the code for running the function but I get a type mismatch error. What do you think? Kirk, I use 9.3 and I am not sure for your remark. | |
| Oct 5, 2011 at 13:12 | comment | added | Kirk Kuykendall | This dll was posted to arcscripts in 2003. If clsThPoly implements the ICommand interface from arcgis 8.1 or whatever, wouldn't this explain the behavior you're seeing if you don't have 8.1 installed? | |
| Oct 5, 2011 at 9:34 | history | edited | Mike T | CC BY-SA 3.0 |
added 85 characters in body
|
| Oct 5, 2011 at 9:28 | history | answered | Mike T | CC BY-SA 3.0 |