CAD Forum discussion (EN) : click2xls lisp https://www.cadforum.cz/forum_en/ Sat, 16 May 2026 14:43:04 +0000 Wed, 06 May 2020 16:21:59 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://www.cadforum.cz/forum_en/RSS_post_feed.asp?TID=13412 <![CDATA[CAD Forum discussion (EN)]]> https://www.cadforum.cz/forum_en/forum_images/web_wiz_forums.png https://www.cadforum.cz/forum_en/ <![CDATA[click2xls lisp : Hi, I&#039;m having error running...]]> https://www.cadforum.cz/forum_en/forum_posts.asp?TID=13412&PID=37546&title=click2xls-lisp#37546 Author: ampasbeton
Subject: 13412
Posted: 06.May.2020 at 16:21

Hi, I'm having error running this Click2XLS lisp commands.

Command: APPLOAD
Click2XLS.vlx successfully loaded.
Command:
Click2XLS/Text2XLS commands loaded. (C)2016, www.cadstudio.cz
__________ CAD/GIS custom application development ___________
Command: (setq Click2XLSDebug T)
T
Command: CLICK2XLS
Export clicked coordinates to an Excel sheet
"CLSID={00024500-0000-0000-C000-000000000046} - should be {00024500-0000-0000-C000-000000000046}"
"EXEname=C:\\Program Files (x86)\\Microsoft Office\\Root\\Office16\\EXCEL.EXE /automation - LocalServer32"
"EXEname=C:\\Program Files (x86)\\Microsoft Office\\Root\\Office16\\EXCEL.EXE /automation - LocalServer"
"EXEname=C:\\Program Files (x86)\\Microsoft Office\\Root\\Office16\\EXCEL.EXE /automation - Wow6432Node"
"EXEname=C:\\Program Files (x86)\\Microsoft Office\\Root\\Office16\\EXCEL.EXE /automation - Wow6432Node LocalServer32"
"ProgID=Excel.Application.16 - Software"
"ProgID=Excel.Application.16 - Wow6432Node"
"EXEname=C:\\Program Files (x86)\\Microsoft Office\\Root\\Office16\\EXCEL.EXE - final"
Error: ActiveX Server returned an error: Error loading type library/DLL
Command:


Are there any solution to this? I remember using click2xls lisp 2 years ago without any problem.
*I've tried reinstalling AutoCAD (2017) 
*I used this version (I suppose this is the most updated version)
Click2XLS/Text2XLS - export clicked point coordinates or picked texts to Excel sheets (VLX Lisp for AutoCAD)21kB9.4.2020
V1.6

*and I don't think there is any problem with my Microsoft Excel (2019-32bit), opening excel files just fine

Thanks in advance


Edited by ampasbeton - 06.May.2020 at 17:07]]> Wed, 06 May 2020 16:21:59 +0000 https://www.cadforum.cz/forum_en/forum_posts.asp?TID=13412&PID=37546&title=click2xls-lisp#37546 <![CDATA[click2xls lisp : You are welcome. ]]> https://www.cadforum.cz/forum_en/forum_posts.asp?TID=13412&PID=37528&title=click2xls-lisp#37528 Author: Vladimir Michl
Subject: 13412
Posted: 11.Apr.2020 at 00:00

You are welcome.]]> Sat, 11 Apr 2020 00:00:20 +0000 https://www.cadforum.cz/forum_en/forum_posts.asp?TID=13412&PID=37528&title=click2xls-lisp#37528 <![CDATA[click2xls lisp : That was it!!!!!Office downloaded...]]> https://www.cadforum.cz/forum_en/forum_posts.asp?TID=13412&PID=37527&title=click2xls-lisp#37527 Author: john lav
Subject: 13412
Posted: 10.Apr.2020 at 22:53

That was it!!!!!

Office downloaded by default the 32bit version and the lisp could not locate the path. There was no way to download the 64bit version of office 19 for some reason and after trying everything, finally i found a soloution... 

I had a copy of office 2016 64 bit and installed it first. Then tried to install office 2019. Fortunately the instalation of the 64 bit version of office 2016 forced it to install the same 64 bit version of office 2019.... Unistall office 2016 (no licence for this) and everything seems to work fine.

Then you very much!!!!!! 
]]> Fri, 10 Apr 2020 22:53:14 +0000 https://www.cadforum.cz/forum_en/forum_posts.asp?TID=13412&PID=37527&title=click2xls-lisp#37527 <![CDATA[click2xls lisp : There were just two more debug...]]> https://www.cadforum.cz/forum_en/forum_posts.asp?TID=13412&PID=37526&title=click2xls-lisp#37526 Author: Vladimir Michl
Subject: 13412
Posted: 10.Apr.2020 at 08:09

There were just two more debug messages in the updated version. But if you have your Excel in a different folder, this is probably the source od the problem. Click2XLS uses the official, registry-based method to detect the Excel version and location. If you have it in fact located in a different folder, the Office installation is damaged. You have probably installed both versions (32 + 64-bit) and then non-standardly canceled or uninstalled one of them. Perform a repair installation.

BTW, if you double-click on an XLSx file in Windows Explorer, does it open in Excel properly?

]]> Fri, 10 Apr 2020 08:09:37 +0000 https://www.cadforum.cz/forum_en/forum_posts.asp?TID=13412&PID=37526&title=click2xls-lisp#37526 <![CDATA[click2xls lisp : Command: (LOAD &#034;C:/Users/John...]]> https://www.cadforum.cz/forum_en/forum_posts.asp?TID=13412&PID=37525&title=click2xls-lisp#37525 Author: john lav
Subject: 13412
Posted: 09.Apr.2020 at 22:50

Command: (LOAD "C:/Users/John Lav/Downloads/Click2XLS.vlx")
Click2XLS/Text2XLS commands loaded. (C)2016, www.cadstudio.cz
_________ CAD/GIS custom application development ___________ nil

this is the message i get when i load the lisp, if that helps
]]> Thu, 09 Apr 2020 22:50:44 +0000 https://www.cadforum.cz/forum_en/forum_posts.asp?TID=13412&PID=37525&title=click2xls-lisp#37525 <![CDATA[click2xls lisp : same error....the folder that...]]> https://www.cadforum.cz/forum_en/forum_posts.asp?TID=13412&PID=37523&title=click2xls-lisp#37523 Author: john lav
Subject: 13412
Posted: 09.Apr.2020 at 22:49

same error....

the folder that the EXCEL.exe located in my pc is Program files x86 not Program files, could this be any relevant to the error? Don't know much of programming but i just notice the path...
]]> Thu, 09 Apr 2020 22:49:03 +0000 https://www.cadforum.cz/forum_en/forum_posts.asp?TID=13412&PID=37523&title=click2xls-lisp#37523 <![CDATA[click2xls lisp : It looks like this is not the...]]> https://www.cadforum.cz/forum_en/forum_posts.asp?TID=13412&PID=37522&title=click2xls-lisp#37522 Author: Vladimir Michl
Subject: 13412
Posted: 09.Apr.2020 at 22:38

It looks like this is not the latest version. I have added some more debug prints, can you please redownload and load the new VLX file (e.g. by mouse-dragging onto your AutoCAD window). The debug printouts look fine so far.]]> Thu, 09 Apr 2020 22:38:05 +0000 https://www.cadforum.cz/forum_en/forum_posts.asp?TID=13412&PID=37522&title=click2xls-lisp#37522 <![CDATA[click2xls lisp : when i type the command with the...]]> https://www.cadforum.cz/forum_en/forum_posts.asp?TID=13412&PID=37521&title=click2xls-lisp#37521 Author: john lav
Subject: 13412
Posted: 09.Apr.2020 at 20:07

when i type the command with the parenthesis () it returns: T
and after i run the lisp it returns:

Export clicked coordinates to an Excel sheet
"CLSID={00024500-0000-0000-C000-000000000046} - should be {00024500-0000-0000-C000-000000000046}"
"EXEname=C:\\Program Files\\Microsoft Office\\Root\\Office16\\EXCEL.EXE /automation - LocalServer32"
"EXEname=C:\\Program Files\\Microsoft Office\\Root\\Office16\\EXCEL.EXE /automation - LocalServer"
"EXEname=C:\\Program Files\\Microsoft Office\\Root\\Office16\\EXCEL.EXE /automation - Wow6432Node"
"EXEname=C:\\Program Files\\Microsoft Office\\Root\\Office16\\EXCEL.EXE /automation - Wow6432Node LocalServer32"
"ProgID=Excel.Application.16 - Software"
"ProgID=Excel.Application.16 - Wow6432Node"
"EXEname=C:\\Program Files\\Microsoft Office\\Root\\Office16\\EXCEL.EXE - final"
Error: bad argument type: VLA-OBJECT nil

thnx for getting back to me so soon!!!
]]> Thu, 09 Apr 2020 20:07:51 +0000 https://www.cadforum.cz/forum_en/forum_posts.asp?TID=13412&PID=37521&title=click2xls-lisp#37521 <![CDATA[click2xls lisp : Are you sure you are using the...]]> https://www.cadforum.cz/forum_en/forum_posts.asp?TID=13412&PID=37519&title=click2xls-lisp#37519 Author: Vladimir Michl
Subject: 13412
Posted: 09.Apr.2020 at 18:34

Are you sure you are using the latest version of Click2XLS from the Download page here? If so, please type the following command into your AutoCAD command line and then start Click2XLS again. What does it say now?

Command: (setq Click2XLSDebug T)


]]> Thu, 09 Apr 2020 18:34:39 +0000 https://www.cadforum.cz/forum_en/forum_posts.asp?TID=13412&PID=37519&title=click2xls-lisp#37519 <![CDATA[click2xls lisp : Hi,I am using the click2xls lisp...]]> https://www.cadforum.cz/forum_en/forum_posts.asp?TID=13412&PID=37518&title=click2xls-lisp#37518 Author: john lav
Subject: 13412
Posted: 09.Apr.2020 at 17:54

Hi, 
I am using the click2xls lisp for more than two years and worked perfectly no matter the version of autoCAD or Office.
Recently, i bought a new pc and install AutoCAD map 2016 (have the same in my laptop) and i bought ms office 2019 for first time. 
Now, when i try to use the lisp at me new pc i keep getting this error message:

Export clicked coordinates to an Excel sheet
Error: bad argument type: VLA-OBJECT nil  

Just tried some other .vlx lisps and works just fine.
Any help????

thnx
]]> Thu, 09 Apr 2020 17:54:23 +0000 https://www.cadforum.cz/forum_en/forum_posts.asp?TID=13412&PID=37518&title=click2xls-lisp#37518