How to produce script/lsp using excel ?

[kelvxd92]

lovely day everyone !

I'm a structural engineer and looking to enhance my detailing speed. However, i'm not really good in programming but i found some of the examples online as per attached below. (i apologize for not crediting as i forgot where i downloaded this). Basically, the attachment have 3 files that comes with excel, dwg and lsp file. To begin, input the excel data and it will regen the lsp file and follow by loading the lsp in autocad. It's really amazing how this can be done and i wish to see how they create the macro in excel (if im not mistaken). Does anyone here can suggest or comment on how to produce script or lsp via excel ? 

I'm happy with everyone to share their thoughts. Apart from that,  i need some advice on the difference between lsp and visual lsp with some relevant example that shows the differences in them. I'm really keen to learn this awesome stuff and would be grateful if anyone could share their materials/lectures as my fundamentals in programming is still weak.

Regards,

Kelvin

[dbroad]

If you want advice about how the author created the excel spreadsheet, the honorable thing to do would be to ask him.  The vba code is password protected so I can only assume that he intended to protect his code from reverse engineering.  If you purchased the software, it might be a violation of your license agreement to post the code publicly.  The style of the generated code is not that great though so I wouldn't spend much time recreating it or editing it.

Your LISP questions are too broad.  AutoCAD has documentation for its autolisp functions and there are a wealth of examples here for how to program.  Vlisp just gives you access to the activeX functionality. It is still autolisp.

For the illustrated purposes, a well done, dynamic block sounds like it would do the job better than a program.