Leaderboard

That is odd I had a look at multiple puts just pasted to command line and excel values were there. It was instant. The excel Iuse this on has look up tables etc and shows no sign of being slow. (ahputcell "B11" "Yes") (ahputcell "B12" "no") (ahputcell "B13" "1") (ahputcell "B14" "2") (ahputcell "B15" "3") (ahputcell "B16" "6") It sounds like something in your excel is slowing it down.

It can be faster to select by range and vlax-put than to select cells one by one and vlax-put. or If .xls or .xlsx are heavy, how about using a .csv file? http://www.lee-mac.com/writecsv.html It will be a little lighter.

no your right @Steven P that lisp i linked you have to refedit the main block then step down to the nested one. so its (last (last

While undefining OPEN will work, you will need to re-define the command, and perhaps include error checking to restore OPEN in the event of an error. IMO - It's far better to have a separate command for this. With the OPENR command, you can invoke from the command line like so: (defun _OPENR (f) (_OpenReadOnly f)) (defun _OpenReadOnly (f) ;; Example (_OpenReadOnly "C:\\file.dwg") (princ "\nOPEN READ-ONLY ") (vl-load-com) ((lambda (acApp) (if (/= 1 (getvar 'sdi)) (if (findfile f) (vla-activate (vla-open (vla-get-documents acApp) f :vlax-true)) (prompt "\n** File not found ** ")) (prompt "\n** Command not available in SDI mode ** "))) (vlax-get-acad-object)) (princ))