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

learn more… | top users | synonyms

0
votes
1answer
31 views

How to pass a variable (FilesToAdd) from VBA script (interface) to a Mapbasic program?

Option Explicit Public FilesToAdd As Integer Private Sub TEST_Click() FilesToAdd = 1 Dim b As Variant Dim Prog As String Dim File As String Prog = "C:\Program ...
3
votes
0answers
372 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
122 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
310 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
274 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
96 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
56 views

ArcGIS macros question

How to call a UserForm appearance from a macros? (A click on a button on a panel calls a UserForm and then I work with commands that are in a userform) Solved: a stupid reason - macro and userform ...
1
vote
0answers
88 views

Can Geomedia be automated using VBA

Can I automate Geomedia using VBA? The Geomedia training manual "Fundamentals of Geomedia Development Part 1" talks about automating using visual basic but I do not have Visual Basic.
1
vote
0answers
103 views

How to capture GPS co-ordinates from a Microsoft InfoPath form on a mobile device

We are looking for a way to capture GPS coords through the Microsoft INFOPATH form which is loaded on our Mobile Motion device. Basically, we are trying to put a VB script behind the “Get GPS Coord” ...
1
vote
0answers
64 views

How to create a startup prompt that populates definition queries on multiple feature classes

I would like to create an ArcGIS start up prompt or custom button that asks for a user's initials and then populates multiple feature class & layer definition queries. More specifically, I would ...
1
vote
0answers
102 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
199 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
61 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
47 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
195 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
386 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 ...
1
vote
0answers
423 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
167 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
254 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
198 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
121 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
48 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
265 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 ...
1
vote
0answers
271 views

Export topology tables to txt files using ArcObjects, generating directed graph, and finding intersections

I want to export topology tables to text files: for points: 1 id x y for lines: line id fompoint.x from point.y topoint.x topoint.y for polygons: id line id 1, line id 2... 2 arc ...
0
votes
0answers
176 views

Converting VB code to C# for coverting Polyline to polygon

It is a while that I am stuck at converting polylines to polygon and I couldent find any solutions into it.I have tried some diffrent methods like using ...
0
votes
0answers
15 views

How Do I simply display the Coordinate Info of any vector format (.Shp,.gdb,.mdb) in a textbox using VB in ARCGIS

I've made an interface using VBA Macros to show the existing coordinate system information of the input vector file in a textbox by clicking on code button. And if I defined the projection and if it ...
0
votes
0answers
27 views

Add point and update column incremental

In existing feature class we need to add point and some column value need to be updated in incremental using vba code i have some sample code please any can modify it? Private Sub ...
0
votes
0answers
160 views

VBA Code to wait until Python returns value

I have written a code in VBA, I am passing parameters to Python and creating a buffer there. After that I am passing that buffer layer and further processing in VBA again. Here is the code for ...
0
votes
0answers
190 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
141 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
115 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
460 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
445 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
152 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
22 views

Segregate and Symbolize using ArcGIS Desktop?

I have a parcels layer with two fields. One containing parcel_category (four categories) and other containing No_of_Units for each parcel category. I want to segregate the parcels layer based on field ...