Getting error while executing VBA Code

**Sahil1087** · 11-08-2012, 10:35 AM

Hi I am getting error while executing below code :-> Compile error : User-defined type not defined

Please Login or Register  to view this content.

Can any tell me is it possible to create PUID as UID instance and pCommand as ICommandItem.

In excel VBA its giving me error.

**Kyle123** · 11-08-2012, 10:38 AM

What are UID and ICommandItem?

They don;t sound like Excel Objects

**Sahil1087** · 11-08-2012, 10:49 AM

Can you please see below link :

http://gis.stackexchange.com/questio...-in-arcobjects

**Kyle123** · 11-08-2012, 10:51 AM

What's that got to do with Excel?

**Sahil1087** · 11-08-2012, 10:58 AM

Hi ,

I have asked one question on this forum but I am not getting reply for that. My question was is it possible to access COM ADD-IN having .dll extension via VBA. From commandbar objects also that is not fesieble according to me.

So I started to search my own and I got this code which is in VB , so I thought is it possible to execute this code in excel VBA.

Have you any Idea about this. How to access COM Add-In via VBA.

**haripopuri** · 11-08-2012, 11:00 AM

Hi Sahil,

Code you have written is not for excel VBA.
Also, always keep code in tags as per forum rules.

**Kyle123** · 11-08-2012, 11:09 AM

Is there a reference to arcGis in references that allow you to add it to your VBA project?

**Sahil1087** · 11-09-2012, 01:37 AM

@Kyle : I have no idea about arcGis. Can you tell how can I check that.

@haripopuri : I think you have not read my question properly, I am trying to ask is it possible to run this code in excel VBA. As I was geting error for that. So my question was related to excel VBA only.

**Kyle123** · 11-09-2012, 02:53 AM

Go to tools > references and the scroll through the list for any likely candidates. Put a Rick box next to then, then look through the object viewer to try and find the classes you are looking for