Working with Visual Lisp and VBA - pass an object ID or entity handle to VBA

[cadpoobah]

I am not a VBA programmer, but am working with one. I have a lisp routine that needs to pass an object ID or entity handle to VBA.

I know that there are ways to use the USERx# variables to allow VBA to grab something set by VL, but I don't think this will work with an object ID. I've also heard it suggested to use the Blackboard in Visual Lisp. I'm not familiar with that.

So, rather than spend a whole lot of time spinning my wheels, I'm going to take the efficient (humble) route and ask for help.

Any suggestions?

Thanks!

[Ed Jobe]

ObjectId's and Handle's are just strings. USERS should work fine if thats the way you want to do it. I prefer to use vb to get an instance of the VL interface and just run the lisp from vba. Search this forum form vlax.cls for a wrapper class that allows you to work with lisp.

BTW ,the BB is only available to lisp, not vba...unless you use the method above and then the point is useless. Lisp runs in the document context and so the bb is used to pass variables from one document context to another...all within lisp. VBA doesn't have this limitation.

[zoomharis]

ObjectId's and Handle's are just strings.

Hi Ed Jobe,
I am afraid that it's long, not string. By the way, is it possible to store data in a custom dictionary using LISP and access it using VBA or vice versa?

[jwanstaett]

Hi Ed Jobe,
I am afraid that it's long, not string. By the way, is it possible to store data in a custom dictionary using LISP and access it using VBA or vice versa?

Yes to this one

[cadpoobah]

ObjectId's and Handle's are just strings. USERS should work fine if thats the way you want to do it. I prefer to use vb to get an instance of the VL interface and just run the lisp from vba. Search this forum form vlax.cls for a wrapper class that allows you to work with lisp.

Thanks for the quick reply, Ed.

IN this case, I will need to keep it so that lisp calls vba. Does this mean then that I can't use (or don't need) VLAX.cls?

If I want to pass a Handle to vb (as a string via a USERS# variable), then I assume that vb can use the handle to the select the object it needs. True? How?

[Ed Jobe]

See the Developer Guide for the HandleToObjectId and ObjectIdToObject methods.