(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
2answers
30 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' ...
9
votes
1answer
176 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
2k 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
25 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
115 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
56 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
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
744 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
26 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
3k 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
62 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
119 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
181 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 ...
7
votes
5answers
12k 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 ...
0
votes
1answer
63 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
55 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
761 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
80 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
14 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
79 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
363 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
88 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
193 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
62 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 ...
0
votes
0answers
26 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
1answer
222 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
394 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
148 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
238 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
119 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
230 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
468 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
266 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
70 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
181 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
1answer
106 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 ...
2
votes
3answers
143 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 ...
3
votes
2answers
784 views

Add-in; Failure to get code to execute when toolbar button pressed

I had written several VBA routines for ArcGIS up through v9.3 and have since upgraded to 10. Since VBA will be a thing of the past in the next version, I downloaded and installed VB Express 2008 and ...
1
vote
1answer
168 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
1answer
180 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
137 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
171 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
323 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 ...
1
vote
0answers
99 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
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
262 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
180 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
2answers
1k views

Collapse layers in ArcMap Table of Contents using ArcObjects

Can someone offer up a Christmas present here? I'm stuck on how to collapse all layers in my ArcMap projects (9.3). I've tried a few bits of sample code, but they all seem to fail for some reason or ...
2
votes
0answers
116 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" ...