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 sheetError: bad argument type: VLA-OBJECT nil  Just tried some other .vlx lisps and works just fine.Any help????thnx

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)

when i type the command with the parenthesis () it returns: Tand 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 nilthnx for getting back to me so soon!!!

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.

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

Command: (LOAD "C:/Users/John Lav/Downloads/Click2XLS.vlx") Click2XLS/Text2XLS commands loaded. (C)2016, www.cadstudio.cz _________ CAD/GIS custom application development ___________ nilthis is the message i get when i load the lisp, if that helps

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?

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!!!!!! 

You are welcome.

Hi, I'm having error running this Click2XLS lisp commands.Command: APPLOADClick2XLS.vlx successfully loaded.Command:Click2XLS/Text2XLS commands loaded. (C)2016, www.cadstudio.cz__________ CAD/GIS custom application development ___________Command: (setq Click2XLSDebug T)TCommand: CLICK2XLSExport 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/DLLCommand: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.2020V1.6*and I don't think there is any problem with my Microsoft Excel (2019-32bit), opening excel files just fineThanks in advance


ampasbeton2020-05-06 17:07:46