AnsweredAssumed Answered

Fastest way of using the tools created using VBA in Arc GIS 10?

Question asked by theyidar on Feb 1, 2012
Latest reply on Feb 2, 2012 by Hornbydd
Hello all,

This question might have been asked or discussed before but I have not really found out my answers after my quick search in the forum.

I have this tool that i created using VBA in ArcGIS 9.3. The tool basically selects a feature, finds the related time series table for the selected feature from a geodatabase and creates a time series graph.

We finally migrated to ArcGIS 10 and I just figured out that ArcGIS 10 will be the last version that will be supporting VBA.
I installed the VBA extension for ArcGIS 10 and got the authorization code from ESRI with the hope that the tools created in 9.3 would work right away but unfortunately they did not work.

I am really on a short schedule and in the short run I need to make these tools run.
What would be the best solution for me? Is it possible that I might be missing some references or objects or libraries that changed in version 10? I was hoping that by installing the VBA extension the code would work as it is (It was working fine in version 9.3)

As I run it it gives the follwing error "application define or object defined error" for the following lines

Sub graph_timeseries()
    Dim pDoc As IMxDocument
    Dim pMap1 As IMap
    Dim sLayerName As String
    Dim sCompName1 As String
    Dim sCompName2 As String
    Dim FeatureID() As Integer
    Set pDoc = ThisDocument
    Set pMap1 = pDoc.FocusMap
    sLayerName = ""
    sCompName1 = ""

Thanks a lot for the help already.