(Visual Basic for Applications) A subset of Visual Basic that provides a common language for customizing Microsoft applications.

learn more… | top users | synonyms

3
votes
0answers
188 views

VBA Convert decimal degree to Meters button

I have 2 data frames one which has WGS data in it and the other OSGB1936. I am trying to create a button where the user can input decimal degrees (WGS) and it will zoom them to that location in ...
2
votes
0answers
43 views

Matching points in table to polygons

this is my first post to this forum. I hope to start participating actively. I have a table with several records (aprox 200.000), each with its own coordinates. And I need to identify the "Polygon" ...
2
votes
0answers
92 views

Rotate Selected Features ArcGIS 10 - VBA

I am attempting to loop through polygon features and rotate pairs of features by a specified angle. Pseudo logic: 1) Open up a standalone table in the map document and retrieve a unique identifier ...
2
votes
0answers
108 views

Getting layers from SDE with vba

Im running arcmap 9.1. i have the code that lists feature classes in a list box from the SDE. The users select from one list box and adds it to another list box. How do i get it to show the layer name ...
2
votes
0answers
90 views

How to solve a filename conflict problem?

I use a procedure to remove and delete a feature layer with a certain name. Then, using another procedure which is called during the run time of the program (as the remove and delete procedure as ...
1
vote
0answers
32 views

InsertFeature on a versioned layer [vba]

I am writing an application that takes data from an Excel Spreadsheet and loads it into an ArcSDE feature class. The Feature class is editable within ArcMap, but I am having trouble inserting a ...
1
vote
0answers
43 views

Quering a ArcSDE featureclass attribute table after joining

I am trying to query a ArcSDE Feature Class after joining using Iqueryfilter I have two SDE feature classes. 1) Subdivisions : which has details of subdivision and districts (parent) 2) ...
1
vote
0answers
35 views

Joining a In_memory table with an SDE table

I have a in memory table that gets created, and want to join it to a table from SDE. I have tried the following code. Private Sub JoinTables(sdetable As ITable, inMemoryTable As ITable, joinField As ...
1
vote
0answers
40 views

VBA to ActiveX tool

I have several scripts that I create UIcontronButton from, but I really want to create a dll from the scripts so I dont have to copy paste scripts on every computer. How do I create arcmap tool dll?
1
vote
0answers
120 views

Relative paths in ArcScene document are broken if opened programmatically

When I open ArcScene document with relative paths programmatically from ArcMap, all those paths are broken. The location in source tab for broken layers is set to some different path like ...
1
vote
0answers
262 views

Error creating IPoint (ArcGIS 10) - Invalid use of New keyword (VBA)

I have some code I wrote in 9.3 that (mostly) works in version 10. I have a UIToolControl that buffers a user-input point based on a mouse click - nearly identical to the sample. This used to work ...
1
vote
0answers
112 views

How can I denote the values of reclassification using variables?

I used the following lines of code to classify a raster. However, my problem is how can I denote the old and new classification values in the last code line using variables? Then number of values ...
1
vote
0answers
188 views

Extract by mask run time error in VBA

I have the following script language code shown below within a main code just to run the tool of spatial analyst "Extract by mask". Unfortunately, when I run it I get a Run Time Error. I checked file ...
1
vote
0answers
151 views

vba code for algorithm to assign track file gps UTM coordinates (East Africa) to an overlay 5x5km grid cell

The GPS coordinates are temporarily imported in to an Access database from DNR Garmin files downloaded (as dbf file(s)), and then exported for mapping in AEJEE (ArcExplorer Education Edition). I need ...
1
vote
0answers
112 views

Arcobjects - Properties Grid

Does anybody know a way, in VBA, to change the grid interval? For example: if my layout´s scale is 1:2000, my grid will have 200 meters interval and my layout´s scale is 1:5000, my grid will have 500 ...
1
vote
0answers
43 views

How do I get non modal .dll things to work in ArcGIS 9 Education edition?

I dont know if I have installed it correctly on my computer. I think I need Non-Modal Forms Support in Visual Basic DLLs? and forcing VBA to load automatically in ArcGIS 9?
1
vote
0answers
231 views

topology rules for structuring topology data to get line feature as topoparent in topology graph

i Created topology graph of a polygon feature and i copied geometry of topology edges into line feature class,and topology nodes into point feature class i created topology layer containing ...
0
votes
0answers
28 views

What is the easiest way to calculate borehole deviation?

Does anyone know if there was a program or specific method (calculations) in order to create a deviation value based on querying specific geological and drilling variables?
0
votes
0answers
45 views

Remove unused references in ArcGIS 9.3.1 vba

Can anyone suggest me how will I find and remove unused references used in a project done in ArcGIS 9.3.1 vb6. Thanks Khaled
0
votes
0answers
52 views

Finding gaps between polygons

I am trying to build procedure for finding gaps and convert the procedure steps in to code, but i am finding some difficulty, i wonder if someone can help me with it. the steps i planned in seek of ...
0
votes
0answers
178 views

Linking an MS Access OLE Object to a KML with VBA

I have a VBA script that creates a blank KML and writes to it, pulling from query fields to populate the description/pop-up bubble, and the place marks (from a coordinates field in the Access DB). ...
0
votes
0answers
89 views

Run time error for GP objects

I have a code with toolbars which I tried to run it in another PC but it failed. I get a run time error "Method Addtoolbox of object I GDispatch failed". The line that the code stacks is the last one ...
0
votes
0answers
285 views

Open the IGxDialog in MS Access 2010 using VBA

I hope this is the right forum for this question. I have a program in MS Access that allows users to input varius aspects related to land treatments including the spatial information (point, line, or ...
0
votes
0answers
337 views

Problem with calendar object in VBA (ArcGIS 9.3.1, Windows 7)

I have an application (that wasnt created by me), which was created on Win Xp, the user it was created for now has Windows 7. The userform has a calendar control, but when they try and run the ...
0
votes
0answers
237 views

How to solve a Run-time error 91?

I have a function which a part shown below. The problem is that I get a Run-time error 91 (object variable or with variable not set) and the debug highlights the last line of the code ( Set ...
0
votes
0answers
95 views

How to make sure OnSketchFinished always works?

In my VBA application i have a listener setup that listens for OnSketchFinished, when the polygon is created a messagebox appears and then a userform. My problem is that the listener will work 90% of ...
-1
votes
0answers
42 views

Need help with VBA code for filling a table

Bonjour a tous; je travail VBA dans arcgis 9.3 j'ai crée un formulaire avec une liste déroulante et une liste texte et autre controls: quand je sélectionne un type de station dans la liste ...