topic Re: Using Geoprocessing tools in VBA in ArcObjects SDK Questions

Using Geoprocessing tools in VBA

JeanJuengling — Mon, 09 Nov 2009 14:42:33 GMT

When trying to import some 9.3.1 VBA code in 9.4, I get a run-time error '21474672559 (80004005)' on the GP.Toolbox line below:

Dim GP As Object
Set GP = CreateObject("esriGeoprocessing.GpDispatch.1")
GP.Toolbox = "C:\Program Files\ArcGIS\Desktop9.4\ArcToolbox\Toolboxes\Analysis Tools.tbx"

Is it still possible to access the geoprocessing tools this way?

Using Geoprocessing tools in VBA

RalfGottschalk — Mon, 09 Nov 2009 22:10:16 GMT

Yes it will be possible to create the Geoprocessor this way at 9.4. However, this does not work right now at Beta 1. This is a known issue and the tracking number is NIM049770.

GpDispatch is not working from vbscript either

curtvprice — Wed, 13 Jan 2010 22:01:38 GMT

I'm having the same issue with beta 1 using script tools written in vbscript that access the geoprocessor through gpdispatch.

You can add me to the list!

Re: GpDispatch is not working from vbscript either

curtvprice — Mon, 03 May 2010 18:47:34 GMT

I'm having the same issue with beta 1 using script tools written in vbscript that access the geoprocessor through gpdispatch.

You can add me to the list!

Still having this problem. Error popup message follows:

Could not create object named "esriGeoprocessing.GPDispatch.1".

ArcMap 10.0 PR 1 (Build 2348)

Re: Using Geoprocessing tools in VBA

jessieleo — Mon, 03 May 2010 19:04:17 GMT

Yes it will be possible to create the Geoprocessor this way at 9.4. However, this does not work right now at Beta 1. This is a known issue and the tracking number is NIM049770.

I was told that ARCGIS 9.4(10) doesnot support VBA anymore. is it right?

Jessie

Re: Using Geoprocessing tools in VBA

curtvprice — Mon, 03 May 2010 19:43:25 GMT

Jesse, VBA is supported, but requires a special install.

In truth, I'm trying to use VBScript, not VBA. Can someone help?

Re: Using Geoprocessing tools in VBA

JohnHauck — Mon, 03 May 2010 20:44:34 GMT

I've also tested this issue at the current build 2396 and it's still a problem. It was fixed for build 2217 but is now a problem again. I will provide some additional information as soon as possible.

Re: Using Geoprocessing tools in VBA

JohnHauck — Mon, 03 May 2010 21:48:52 GMT

After further investigation I found out that this is a known issue (NIM057021) that the problem came up again and should be resolved for the final build.

Re: Using Geoprocessing tools in VBA

curtvprice — Thu, 06 May 2010 21:33:21 GMT

Jim, i would be happy to test a patch if that will help. This is needed functionality!