topic Re: VBA Toolbar after Upgrade to 10 is not Working in ArcObjects SDK Questions

VBA Toolbar after Upgrade to 10 is not Working

JanetRogers — Tue, 28 Dec 2010 01:03:21 GMT

I have manually added a toolbar to a document and created a number of macros in VBA which are run from the toolbar. These work perfectly in 9.3.1 however in 10, the buttons show [Missing ...] and of course no longer work.

We have been told that the only solution is to re-write the Macros in VB.NET - which is in the plans - however my understanding was that 10 should run VBA, even if it no longer supported. I would appreciate it if someone could suggest what is the problem here.

The extra VBA module has been installed with ArcMap 10 and a licence provided by ESRI is being used.

Re: VBA Toolbar after Upgrade to 10 is not Working

Venkata_RaoTammineni — Tue, 28 Dec 2010 03:11:33 GMT

I have manually added a toolbar to a document and created a number of macros in VBA which are run from the toolbar. These work perfectly in 9.3.1 however in 10, the buttons show [Missing ...] and of course no longer work.

We have been told that the only solution is to re-write the Macros in VB.NET - which is in the plans - however my understanding was that 10 should run VBA, even if it no longer supported. I would appreciate it if someone could suggest what is the problem here.

The extra VBA module has been installed with ArcMap 10 and a licence provided by ESRI is being used.

hi,

http://help.arcgis.com/en/sdk/10.0/vba_desktop/ao_home.html

Re: VBA Toolbar after Upgrade to 10 is not Working

JanetRogers — Wed, 29 Dec 2010 02:24:12 GMT

Thank you - I know that eventually I will need to convert everything across, but for the moment I need an answer to my question about 10 not supporting existing VBA, as I don't have time to convert all the macros at once and my client needs this to work urgently.

Re: VBA Toolbar after Upgrade to 10 is not Working

RichardWatson — Wed, 29 Dec 2010 11:53:17 GMT

I haven't a clue what the underlying issue is.

Since you stated that your need was "urgent" then a possible workaround might be for you to develop a non-VBA component to add to the toolbar which calls your VBA logic within it.

Perhaps that will resolve the "urgent" problem until you can get an answer from ESRI support or another user.

Re: VBA Toolbar after Upgrade to 10 is not Working

JanetRogers — Fri, 31 Dec 2010 06:36:15 GMT

I haven't a clue what the underlying issue is.

Since you stated that your need was "urgent" then a possible workaround might be for you to develop a non-VBA component to add to the toolbar which calls your VBA logic within it.

Perhaps that will resolve the "urgent" problem until you can get an answer from ESRI support or another user.

I was really just interested in finding out whether anyone else had had the same problem. The urgency is that the client is impatient to get all his computers running 10; the one with the toolbar has been set back to 9.3.1 to enable it to keep working. It was my understanding that VBA should still work with 10 - is this correct?

Re: VBA Toolbar after Upgrade to 10 is not Working

GregoryRoss — Sat, 01 Jan 2011 23:39:50 GMT

http://blogs.esri.com/Dev/blogs/arcgisdesktop/archive/2009/10/28/ArcGIS-Desktop-and-VBA_3F00_.aspx

Re: VBA Toolbar after Upgrade to 10 is not Working

VivekPrasad — Sun, 02 Jan 2011 03:56:06 GMT

I have manually added a toolbar to a document and created a number of macros in VBA which are run from the toolbar. These work perfectly in 9.3.1 however in 10, the buttons show [Missing ...] and of course no longer work.

We have been told that the only solution is to re-write the Macros in VB.NET - which is in the plans - however my understanding was that 10 should run VBA, even if it no longer supported. I would appreciate it if someone could suggest what is the problem here.

The extra VBA module has been installed with ArcMap 10 and a licence provided by ESRI is being used.

Hi,
To confirm whether VBA has been installed and authorized properly, please check if you can open VBA Editor from your ArcMAP 10.0 (you can use Alt + F11 as short cut). Installing and authorizing VBA should allow the buttons to show up and be used.

Vara Prasad M S
GIS Analyst.