View Full Version : Capture variables w/ VBA
2008-05-18, 04:22 PM
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?
2008-05-19, 02:40 PM
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".
2008-05-20, 02:22 AM
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.
2008-05-20, 02:29 PM
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.
Powered by vBulletin® Version 4.1.11 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.