I'm sure this has a shamefully simple answer- but I just cant seem to get it.
I would like to declare a variable strongly enough that I can reference it from another application.
"Public X as single" doesnt seem to do it. How do a give a variable the kind of scope I need?!
Detail: I have a variable in a piece of VBA code in an ArcView 8 map called X. Some code VBA code in Arc8 opens an MS Access database and runs a macro. The macro opens a form and I would like a field in the form to automatically populate to X, a variable defined in AV 8.
Help??
Thanks-
ps- have searched forums and still cant find enough clues to do this on my own....
I would like to declare a variable strongly enough that I can reference it from another application.
"Public X as single" doesnt seem to do it. How do a give a variable the kind of scope I need?!
Detail: I have a variable in a piece of VBA code in an ArcView 8 map called X. Some code VBA code in Arc8 opens an MS Access database and runs a macro. The macro opens a form and I would like a field in the form to automatically populate to X, a variable defined in AV 8.
Help??
Thanks-
ps- have searched forums and still cant find enough clues to do this on my own....