Capture variables w/ VBA

[johannvonspiralspine]

Hi

I have a AutoLISP program that defines a series of variables. I want to capture those variables using a VB macro then transfer them to an excel spreadsheet.

Does anyone have a sample of code I could use to accomplish this?

Thanks

[Ed Jobe]

I find it easier to COM in vba, however, Lisp can do COM. Search either the lisp forum or the vba forum for "excel". If you want to use vba, I would do all of it in vba and abandon your old lisp...especially if all it does is "define a series of variables".

[johannvonspiralspine]

I cant abandon the LISP. Its a mega drawing program. All of the variables are actually defined in VB, then transferred to the LISP. I've been unloading my forms as a reset for troubleshooting and I was planning to keep that in the case users need to make multiple drawings.

Thanks.

[Ed Jobe]

Well, you can still work with xl in lisp or vba, its your choice. In vba you can also retrieve your lisp variables. Search this forum for vlax.cls.