I'm currently in the process of porting an extension for ArcGIS 9 written in VBA to ArcGIS 10. Most of it works without much rework.
However, there's one thing left that I couldn't solve despite hours of googling: In ArcGIS 9, we used the a modified version of Kristina Callahans AccessHyperlink script. It was called as a macro.
In ArcGIS 10, I have to write a VBScript function (or python or whatever), I cannot just call one that already exists in the VBA environment as before. So how can I do that?
Say for example, I have an VBA project named "MyProject" that contains a module "modHyperlink" with a VBA function "Hyperlink". I want to call this VBA function when the hyperlink tool is used, passing some data as parameters. The actual VBA function is rather large and does lots of database work, so I don't want to recreate it in VBScript.
Ideas? Thanks in advance for any help!