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

learn more… | top users | synonyms

1
vote
1answer
489 views

Using kriging with data in GDB

I have series of data in my GDB I am running the program under VBA and what I want to do is using the data by the tool Kriging. This is what I thought: First, Kriging needs data that must be a ...
-2
votes
1answer
34 views

Adding VBA code to ArcMap

I have a VBA code and I need to add it to ARCMap 10.2.2 but not sure how to do it I couldn't find anything online.
0
votes
1answer
32 views

select by location in vba

I got two Layers (Point and polygons) in my Application and want to write a vb macro, where point layer is cities layer and polygon layer is state's layer, I want to know that how many cities are ...
1
vote
3answers
573 views

Verifying that ArcInfo Workstation is Installed?

What is the best way to verify that a machine has ArcInfo Workstation installed? A code sample in VBA, VB or C# would be great!
2
votes
1answer
1k views

Running Model within ArcMap using VBA?

I would like to Run/execute a model within ArcMap 9.3.1 vba. I can run it in vba by exporting out the VBS script and importing it into vba, however I'm wondering if there is an easier way to just call ...
0
votes
0answers
37 views

How to fill combobox with attrbute data

I am coding using vba in the visual basic editor given ny arcgis9.3, I have u user form,in user form there is a combobox and a commandbutton. I have also added four shape files.so i want to fill the ...
3
votes
2answers
303 views

Getting line FID from polygon ITopologyGraph

I want to export polygon Arc list to txt file for that I created topologygraph for personal geodatabase feature class (polygon) using ITopologyGraph::build. I got polygon FIDs but I am not getting ...
3
votes
1answer
524 views

Setting Spatial Reference for Geometry Bag using ArcObjects and VBA?

Within the ESRI SDK resources there is an example of combining polygons by use of a geometry bag. The following code appears: 'Define the spatial reference of the bag before adding geometries to ...
5
votes
1answer
2k views

How to save a layer file with a relative path

In VBA, how do you save a layer file (.lyr) with a relative path? I have some code that loads a shapefile into ArcMap but I am unsure of how I go about using this shapefile to then save a layer file ...
2
votes
1answer
230 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 ...
2
votes
1answer
154 views

Tutorial on creating python toolboxes?

I've done the ESRI training: Creating Python Toolboxes Using ArcGIS 10.1 but is there anything more in depth? Since VBA is no longer supported in ArcMap 10 and up I'm trying to convert a cross section ...
0
votes
0answers
568 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
482 views

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

I have an application (that wasn't created by me), which was created on Windows XP. The user it was created for now has Windows 7. The userform has a calendar control, but when they try and run the ...
7
votes
5answers
14k views

Snapping points to lines in ArcGIS Desktop and automate using VBA?

I use ArcGIS Desktop and I want create a network with a point feature and a line feature. I need my point features to be on the line features so I should do Snap point to line. However, I do not ...
1
vote
1answer
547 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 ...
4
votes
1answer
322 views

Debugging Visual Basic Code Block in calculate field using ArcGIS Desktop?

From time to time, I have to use Visual Basic in Calculate Field. As the code get bigger, the more complicated is to debug it. And ArcGIS (9.3) does not help as the error messages are, in the best ...
1
vote
2answers
112 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
0answers
413 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
2answers
126 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' ...
11
votes
1answer
214 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 ...
15
votes
5answers
3k views

How can I find the farthest point from a set of existing points?

I have a set of points as a shapefile and I want to find (the coordinates) of a new point which will have the longest possible distance from each of the existing points. Is that possible? If yes, is ...
0
votes
1answer
56 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
376 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
1answer
82 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 ...
1
vote
0answers
13 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
784 views

I want create a crystal report in gis with writing code

I am working in ArcGIS 9.3.1 and I try to write code for creating a crystal report and work with it in VBA, but I recieved an error when the program arrived at this line of code: Dim pProj As ...
0
votes
1answer
37 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 ...
3
votes
3answers
4k views

Polyline length calculation in ArcGIS 10/VB script

I used to run this length calc on my data in ArcGIS 8 and 9, and now it don't work in ArcGIS10. Can you tell me what I have done wrong? Dim dbllength as double Dim pcurve as icurve Set Pcurve = ...
0
votes
1answer
136 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.
2
votes
1answer
271 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 ...
1
vote
1answer
211 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 ...
0
votes
1answer
88 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
58 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
2answers
932 views

Why is * .tlb not visible?

I've created a Visual Studio 08 Active X - MXCommands dll for a VBA button within ArcMap 9.3.1. I'm able to load and use the .tlb on my computer; however when I try it on my test computer the .tlb ...
2
votes
0answers
123 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 ...
1
vote
0answers
123 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.
4
votes
3answers
480 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
148 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
2answers
304 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 ...
1
vote
0answers
69 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
1answer
300 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. ...
3
votes
2answers
579 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
202 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 ...
1
vote
1answer
369 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
166 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 ...
0
votes
1answer
410 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.
2
votes
2answers
714 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
0answers
276 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 ...
2
votes
2answers
3k views

VBA to VB.NET (Visual Studio 10) Migration - ArcMap Focus

I will be migrating several VBA applications currently in ArcMap 9.3.1 to Visual Studio 10 in the near future, and wanted some feedback on the general migration steps listed below. I wanted to make ...
0
votes
1answer
94 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 ...