AutoCAD - click2xls lisp

click2xls lisp

Printed From: CAD Forum
Category: EN
Forum Name: AutoCAD
Forum Description: Discussion about AutoCAD and AutoCAD LT, viewers, DWG and DWF formats, Design Review, AutoCAD 360, add-ons
URL: https://www.cadforum.cz/forum_en/forum_posts.asp?TID=13412
Printed Date: 16.May.2026 at 13:25

Topic: click2xls lisp

Posted By: john lav
Subject: click2xls lisp
Date 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

Replies:

Posted By: Vladimir Michl
Date 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)

-------------
Vladimir Michl (moderator)
ARKANCE - https://arkance.world" rel="nofollow - https://arkance.world - Autodesk Platinum Partner

Posted By: john lav
Date 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!!!

Posted By: Vladimir Michl
Date 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.

-------------
Vladimir Michl (moderator)
ARKANCE - https://arkance.world" rel="nofollow - https://arkance.world - Autodesk Platinum Partner

Posted By: john lav
Date 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...

Posted By: john lav
Date Posted: 09.Apr.2020 at 22:50

Command: (LOAD "C:/Users/John Lav/Downloads/Click2XLS.vlx")

_________ CAD/GIS custom application development ___________ nil

this is the message i get when i load the lisp, if that helps

Posted By: Vladimir Michl
Date 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?

-------------
Vladimir Michl (moderator)
ARKANCE - https://arkance.world" rel="nofollow - https://arkance.world - Autodesk Platinum Partner

Posted By: john lav
Date 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!!!!!!

Posted By: Vladimir Michl
Date Posted: 11.Apr.2020 at 00:00

You are welcome.

-------------
Vladimir Michl (moderator)
ARKANCE - https://arkance.world" rel="nofollow - https://arkance.world - Autodesk Platinum Partner

Posted By: ampasbeton
Date Posted: 06.May.2020 at 16:21

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

Command: APPLOAD

Click2XLS.vlx successfully loaded.

Command:

__________ CAD/GIS custom application development ___________

Command: (setq Click2XLSDebug 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)

21kB

9.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