Discussion forum
CAD discussion |
Please abide by the rules of this forum.
How to post questions: register or login, go to the specific forum and click the NEW TOPIC button.
click2xls lisp |
Post Reply |
Author | |||
john lav
Newbie Joined: 09.Apr.2020 Location: Greece Using: AutoCAD Status: Offline Points: 6 |
Topic: click2xls lisp 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
|
|||
Vladimir Michl
Moderator Group Arkance Systems CZ Joined: 26.Jul.2007 Location: Czech Republic Using: Autodesk software Status: Offline Points: 2015 |
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 Systems - arkance-systems.cz - Autodesk reseller |
|||
john lav
Newbie Joined: 09.Apr.2020 Location: Greece Using: AutoCAD Status: Offline Points: 6 |
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!!!
|
|||
Vladimir Michl
Moderator Group Arkance Systems CZ Joined: 26.Jul.2007 Location: Czech Republic Using: Autodesk software Status: Offline Points: 2015 |
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 Systems - arkance-systems.cz - Autodesk reseller |
|||
john lav
Newbie Joined: 09.Apr.2020 Location: Greece Using: AutoCAD Status: Offline Points: 6 |
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...
|
|||
john lav
Newbie Joined: 09.Apr.2020 Location: Greece Using: AutoCAD Status: Offline Points: 6 |
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
|
|||
Vladimir Michl
Moderator Group Arkance Systems CZ Joined: 26.Jul.2007 Location: Czech Republic Using: Autodesk software Status: Offline Points: 2015 |
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 Systems - arkance-systems.cz - Autodesk reseller |
|||
john lav
Newbie Joined: 09.Apr.2020 Location: Greece Using: AutoCAD Status: Offline Points: 6 |
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!!!!!!
|
|||
Vladimir Michl
Moderator Group Arkance Systems CZ Joined: 26.Jul.2007 Location: Czech Republic Using: Autodesk software Status: Offline Points: 2015 |
Posted: 11.Apr.2020 at 00:00 | ||
You are welcome.
|
|||
Vladimir Michl (moderator)
Arkance Systems - arkance-systems.cz - Autodesk reseller |
|||
ampasbeton
Newbie Joined: 06.May.2020 Location: Indonesia Using: AutoCAD2017 Status: Offline Points: 1 |
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)
*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 |
|||
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0,398 seconds.