Tagged Questions

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

learn more… | top users | synonyms

-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 ...
1
vote
1answer
71 views

Excel Macro to KML using VBA Loop

I am trying to write a VBA loop which will turn a list of addresses and their corresponding Lat Long coordinates in to a KML file for viewing in Google Earth. I have managed to get the opening and ...
1
vote
2answers
32 views

Route hatch labeling as stations (0+00) with vba

I have a route feature which I have set up to label every 500' with the distance along the line. I'd like to use typical stationing format (000+00). I've been using the following VBA script: Function ...
1
vote
2answers
59 views

Cannot convert dms to dd in Excel 2007 using VBA code

I am trying to convert the data in an Excel sheet from dms (degree-minute-second) to dd (decimal degree) format using the vba script available here. Here is sample data: 53° 0' 39.31" 6° 44' ...
10
votes
1answer
191 views

Extracting all points within a certain distance and height difference from a Raster

I have a raster containing tens of millions of points all with X, Y and Z data defined. I need to figure out a simple way to extract and create a new raster or vector with ALL points at a 720 m ...
0
votes
1answer
33 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 ...
0
votes
0answers
206 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 ...
1
vote
0answers
12 views

Making point selection tool using ArcObjects with VBA? [duplicate]

I want to make a selection tool that I can use to select a feature point in ArcGIS for Desktop so I can combine it with a form that I just made to display the form after the feature selected. I use ...
1
vote
1answer
66 views

How to get a Layer as ILayer (ArcObjects)

I had asked this question previously which I think will work. But as I am new to this, I can't figure out how to get a Layer as an ILayer object to pass to the method that's in my previous questions ...
0
votes
1answer
29 views

How to learn arcobject vba? [duplicate]

I am using arcgis from last 3 years. but it was only limited by button pressing. I want to learn arcobject VBA and .NET. kindly help me out. suggest me some reference book or mail me if anyone have a ...
0
votes
1answer
92 views

How to open QGIS using VBA?

Using VBA, I want to open QGIS (the actual GUI) and execute a simple script through the Python console or the editor.
1
vote
1answer
175 views

How to make a Python script that does a task in QGIS?

When I run this code in QGIS Python console it works fine, but I want want to run it from an external Python script. What I want the script to do is: 1- Open QGIS 2- Run this code 3- Close QGIS from ...
0
votes
1answer
71 views

How would I create an input mask for ArcGIS Desktop?

Someone asked me if we can create a simple input mask for geodatabase feature classes so that editing of attributes becomes easier. I am however not sure how this works with ArcGIS 10.x Is this ...
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 ...
2
votes
0answers
95 views

Longest route of a stream in ArcGIS? [closed]

I have a shapefile with polylines representing rivers all over a region. In the attached image, there is an example of one river. The longest route is marked by the two red dots on this river, but ...
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 ...
1
vote
0answers
89 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” ...
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 ...
1
vote
0answers
65 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
2answers
217 views

VBA ArcGIS 9.3 Field Calculator: 'countif' across several fields

I have an attribute table with 15 columns that contain either a '0' or a taxonomy number. I would like a summarized column that shows the number of different species. location type1 type2 type3 ...
3
votes
2answers
457 views

Display Access query in ArcMap

Hi I have an access database and have some built in queries in the database. The same data is stored in geodatabase with the spatial information. Now I want to follow this process: Access->push out ...
0
votes
0answers
163 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 ...
2
votes
2answers
135 views

How to use IFeatureCursorBuffer in VBA

I tried to use IFeatureCursorBuffer to create and dissolve the buffered features.I am trying to get the solution since some days using dissolve and UnionOverlappingBuffers, but not being able to get ...
1
vote
1answer
296 views

remove whitespace Python code results in odd character - Field Calculator

I need to remove whitespace from the end of a string in a field in ArcMap. I tried first the VBA function RTrim, but whitespace still remained. I thought maybe the whitespaces were tabs, so I tried ...
2
votes
2answers
536 views

Create a Line FeatureClass from IPointCollection

I want to create a new line layer from a point layer. I store the points in an IPointCollection. I want to use that IPointCollection to create a line IFeatureClass. I know how to create a single ...
1
vote
1answer
244 views

Getting Coordinates from a feature with VBA

Is there a way to get the longitude and latitude coordinates from a feature class? I have some code which can select the first layer in the Table of Contents. I want to be able to get the lat./long. ...
0
votes
1answer
283 views

How do I copy or edit a cell of attribute table and paste in text file?

I'm new in VBA. I want to copy one cell or optional cell in attribute table and paste in a text file. I'm using ArcGis 10.1.
0
votes
1answer
80 views

Finding points in extent using VBA

Is there a way to select a point from my map's current extent? I want to use ArcObjects to tell me if there is at least one point visible in my extent. I'd like to do this entirely in VBA, and without ...
0
votes
1answer
210 views

Custom data entry in ArcGIS 10

Since VBA support is no longer supported in ArcGIS 10, what is being used out there for custom data entry forms. I'd like to develop something that is very intuitive (for non-GIS users).
2
votes
3answers
156 views

Software needed to recreate VBA forms using python for Arc 10.0

I'm new to programming and need to convert VBA scripted tools for the 10.1 upgrade. I need to recreate the forms and use Python scripting. How do I do this? I need the form to function in 10 ...
1
vote
1answer
192 views

Opening InMemory Table to execute some SQL gives Runtime Error 445 - Object doesn't support this action?

I have a InMemory that gets created, what I then want to do is run INSERT, UPDATE and DELETE queries on the table. The code i have at the moment is below, I create a new InMemory table, add it to the ...
1
vote
1answer
187 views

Software program (or spreadsheet calculations) to find Borehole Deviation?

I was given a bunch of surveyed borehole data (azimuth, depth, dip, geology, etc) and am required to calculate a deviation variable. Besides querying the data and averaging the surveyed borehole ...
0
votes
0answers
193 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?
1
vote
0answers
349 views

Calculating the Centroid of polygon in modelbuilder (VBA to Python) [closed]

Got an easy one, that's got me stuck. I'm moving some models that were created in 9.3.1 to work in 10. Part of the model is calculating the X coordinate of a polygon to a specified field. The code ...
4
votes
3answers
392 views

Where to find books or course materials to help prepare for Esri Technical Certification in ArcGIS Desktop and Developer?

Where I can find books or course materials to help prepare for Esri Technical Certification in ArcGIS Desktop and Developer?
1
vote
0answers
104 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 ...
0
votes
0answers
143 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
1
vote
0answers
202 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) ...
2
votes
0answers
123 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" ...
0
votes
1answer
205 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 ...
2
votes
0answers
312 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 ...
1
vote
0answers
62 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 ...
2
votes
1answer
211 views

Convex Quadrilateral Polygons subdivision in equal parts using Python / OGR

Consider an irregular polygon (P) which has four vertices. I would like to subdivide P into smaller polygons as shown here http://i.stack.imgur.com/4SKhB.jpg In the old days I was using ArcGIS 9.3 ...
1
vote
2answers
806 views

Get Number of Rows, ArcObjects (VBA 6.0)

I am sorry to bother with what may be an easy question for most of you but i am new to ArcObjects (VBA 6.0) in ArcMap (ArcGIS 10.0) and i am really struggling here. I am trying to count the number of ...
2
votes
1answer
111 views

Syntax question for ArcGIS ICalculator object

This is a silly question, but I have this code snippet that I can't figure out: 'Define a calculator for NewArea field pCalculator = New Calculator With pCalculator .Cursor = pCursor ...
0
votes
1answer
63 views

Vba Cons Numbers [duplicate]

I want to make a list of cons numbers(ex. 1,2,3...) in field calculator (VBA). When I am putting for example: (dim d d=[field]+1). The result is all my fields are =1. How to solve this arc map (vba). ...
3
votes
0answers
377 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 ...
3
votes
2answers
717 views

MS Access and geocoding in ArcGIS

We are a small non-profit. We use a fairly complex MS Access application to track everything. We would very much like to geocode addresses in our application and display the results on a map. In ...
1
vote
1answer
214 views

ArcGIS10 VBA requires library references

I just upgraded from ArcGIS 9.2 to 10.0, and I'm trying to create some tools using VBA. It doesn't recognize any of the ArcObjects Classes, Interfaces, or Constants unless the reference includes its ...