sending data between VBA and lisp

[minkadinka]

Hi all.
Can anyone help me with an ongoing problem? I'm using a vba form called from lisp, but am having trouble passing data back to lisp from this form.
I have used the users1-s5 variables successfully in the past but this particular form has about 20 input fields that I need to feed back. Anyone found a solution for a similar problem?

 

[hendie]

how about writing to a temporary file ?

just write the data out in vba
read the data in via Lisp
kill the temporary file

or string the items together in a single list, then use one of the USERSx variable to hold the single string (list) then you will need to parse the list when reading it back in

http://www.resourcecad.com

~ for your CAD solutions

 

[minkadinka]

Thanks Hendie.

Yeah, I'm currently writing out to a temp text and then reading/deleting this temp file within lisp. I've thought of the single list option too, but for reasons too complicated to explain simply it got too messy.
I was hoping to find a simple solution that could take place within acad (ie, no external file needed) but I can't seem to find a solution. It's one of those problems that I know other people must have faced before but I can't seem to find a single instance mentioned anywhere online.

Thanks for your thoughts though.