(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
44 views

Arcmap 10 Visual Basic

im wondering if there is a way to build something like this in Arcmap 10 since VBA isnt supported anymore. Its for my Thesis. I need a tool to handle Polygons and their Information like in the ...
0
votes
0answers
21 views

Replacing text in AutocadMAP File using excel data

I have an autocad drawing with so many light fixtures with all different names.Now we have to change all those names, i already have an excel sheet containing two columns with first one containing ...
1
vote
0answers
38 views

VBA not able to fill all FNODE and TNODE because of large number (1,200,000) of records? [closed]

I need to populate FNODE and TNODE fields for my roads dataset. I have an intersections point feature class that has unique ids, and I need each road segment to have an FNODE and TNODE value that ...
1
vote
2answers
709 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
1answer
495 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
76 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
37 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
583 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
41 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
305 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
526 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
231 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
163 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
590 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
485 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 ...
4
votes
1answer
324 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
127 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
419 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
141 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
224 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
59 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
396 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
789 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
39 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
153 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
291 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
215 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
89 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
59 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
959 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
138 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
129 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
497 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
153 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
321 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
323 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
615 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
211 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
381 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
174 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
442 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
758 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 ...