tag:blogger.com,1999:blog-4011252463639388552.post764340674385116882..comments2024-03-02T06:03:39.401-05:00Comments on JTB World Blog: Visual LISP and ActiveX/VBA ComparisonJTB Worldhttp://www.blogger.com/profile/02249678064305703202noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-4011252463639388552.post-50756835516110692242012-09-15T21:34:43.605-04:002012-09-15T21:34:43.605-04:00Two things that catch my attention are the fact th...Two things that catch my attention are the fact that (apply), (lambda) and (mapcar) have no equivalents in VBA whatsoever, and they are indeed extremely powerful functions. The other is (defun), which you can loosely relate to Function/End Function, but they are VERY different. For starters (and most important) (defun) is dynamically allocated, meaning that it can be redefined at-will, where Function cannot. To mimick (defun) you end up making a crap-load of (if/elseif/else/endif) lines, but even then, you have to be able to predict all the possible permutations you'd want to happen, where (defun) can adapt to nearly unlimited permutations without having to know them in advance. Ok. I apologize for venting, but I'm still sore over how badly Autodesk has left LISP out in the cold.skatterbrainzhttps://www.blogger.com/profile/01375101979702884965noreply@blogger.com