CAD Forum - Database of tips, tricks and utilities for AutoCAD, Inventor and other Autodesk products [www.cadforum.cz]
Czech English Deutsch
Login/Register:
 Visitors: 3289 
RSS tips RSS channel - CAD tips
RSS discussion RSS channel - CAD discussion

Discussion Discussion forum

HelpCAD discussion

CAD Forum - Homepage CAD discussion forum - ask any CAD-related questions here, share your CAD knowledge on AutoCAD, Inventor, Revit and other Autodesk software with your peers from all over the world. To start a new topic, choose an appropriate forum.

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.
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

The information that you provide in this form will make up your forum profile which can be viewed by other forum members. Your email address will only be visible by forum admin and moderators and will be used to send you Forum Notifications. To cancel your account, use the page Opt-out or contact webmaster@cadforum.cz.

click2xls lisp

 Post Reply Post Reply
Author
john lav View Drop Down
Newbie
Newbie


Joined: 09.Apr.2020
Location: Greece
Using: AutoCAD
Status: Offline
Points: 6
Post Options Post Options   Thanks (0) Thanks(0)   Quote john lav Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
Vladimir Michl View Drop Down
Moderator Group
Moderator Group

CAD Studio a.s.

Joined: 26.Jul.2007
Location: Czech Republic
Using: Autodesk software
Status: Offline
Points: 1813
Post Options Post Options   Thanks (0) Thanks(0)   Quote Vladimir Michl Quote  Post ReplyReply Direct Link To This Post 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)
CAD Studio - www.cadstudio.cz - Autodesk reseller
Back to Top
john lav View Drop Down
Newbie
Newbie


Joined: 09.Apr.2020
Location: Greece
Using: AutoCAD
Status: Offline
Points: 6
Post Options Post Options   Thanks (0) Thanks(0)   Quote john lav Quote  Post ReplyReply Direct Link To This Post 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!!!
Back to Top
Vladimir Michl View Drop Down
Moderator Group
Moderator Group

CAD Studio a.s.

Joined: 26.Jul.2007
Location: Czech Republic
Using: Autodesk software
Status: Offline
Points: 1813
Post Options Post Options   Thanks (0) Thanks(0)   Quote Vladimir Michl Quote  Post ReplyReply Direct Link To This Post 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)
CAD Studio - www.cadstudio.cz - Autodesk reseller
Back to Top
john lav View Drop Down
Newbie
Newbie


Joined: 09.Apr.2020
Location: Greece
Using: AutoCAD
Status: Offline
Points: 6
Post Options Post Options   Thanks (0) Thanks(0)   Quote john lav Quote  Post ReplyReply Direct Link To This Post 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...
Back to Top
john lav View Drop Down
Newbie
Newbie


Joined: 09.Apr.2020
Location: Greece
Using: AutoCAD
Status: Offline
Points: 6
Post Options Post Options   Thanks (0) Thanks(0)   Quote john lav Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
Vladimir Michl View Drop Down
Moderator Group
Moderator Group

CAD Studio a.s.

Joined: 26.Jul.2007
Location: Czech Republic
Using: Autodesk software
Status: Offline
Points: 1813
Post Options Post Options   Thanks (1) Thanks(1)   Quote Vladimir Michl Quote  Post ReplyReply Direct Link To This Post 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)
CAD Studio - www.cadstudio.cz - Autodesk reseller
Back to Top
john lav View Drop Down
Newbie
Newbie


Joined: 09.Apr.2020
Location: Greece
Using: AutoCAD
Status: Offline
Points: 6
Post Options Post Options   Thanks (0) Thanks(0)   Quote john lav Quote  Post ReplyReply Direct Link To This Post 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!!!!!! 
Back to Top
Vladimir Michl View Drop Down
Moderator Group
Moderator Group

CAD Studio a.s.

Joined: 26.Jul.2007
Location: Czech Republic
Using: Autodesk software
Status: Offline
Points: 1813
Post Options Post Options   Thanks (0) Thanks(0)   Quote Vladimir Michl Quote  Post ReplyReply Direct Link To This Post Posted: 11.Apr.2020 at 00:00
You are welcome.
Vladimir Michl (moderator)
CAD Studio - www.cadstudio.cz - Autodesk reseller
Back to Top
ampasbeton View Drop Down
Newbie
Newbie


Joined: 06.May.2020
Location: Indonesia
Using: AutoCAD2017
Status: Offline
Points: 1
Post Options Post Options   Thanks (0) Thanks(0)   Quote ampasbeton Quote  Post ReplyReply Direct Link To This Post 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
Back to Top

Related CAD tips:


 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0,094 seconds.