Visual LISP, AutoLISP and General Customization

Visual LISP, AutoLISP and General Customization

Reply
Active Member
JoeMerry
Posts: 9
Registered: ‎12-07-2012
Message 1 of 17 (428 Views)
Accepted Solution

Dimension export routine modification

428 Views, 16 Replies
12-07-2012 01:32 PM

Found this routine online and am hoping to modify it to my needs, just not sure how to proceed.

It exports the text out of the dims into an excel file, the issue I have is that it automatically opens a new book every time you run the lisp with the original workbook open.

I am trying to get it to automatically insert the next set of numbers on the row below the first pull. Any help would be greatly appreciated.

*Expert Elite*
Hallex
Posts: 1,569
Registered: ‎10-08-2008
Message 2 of 17 (411 Views)

Re: Dimension export routine modification

12-08-2012 06:01 AM in reply to: JoeMerry

Hi Joe,

The question is

Do you want to store dim values in the newly created Excel file or

add them all into existig file on particular speadsheet?

Explain details then I can help if I could be able to do it

Also what is your Excel version btw?

_____________________________________
C6309D9E0751D165D0934D0621DFF27919
*Expert Elite*
Hallex
Posts: 1,569
Registered: ‎10-08-2008
Message 3 of 17 (403 Views)

Re: Dimension export routine modification

12-08-2012 09:52 AM in reply to: JoeMerry

Well, rry from this attachment

https://dl.dropbox.com/u/18024145/XLEXPORTTOTEXT.zip

load library then then XLEXPDIM.lsp

_____________________________________
C6309D9E0751D165D0934D0621DFF27919
Active Member
JoeMerry
Posts: 9
Registered: ‎12-07-2012
Message 4 of 17 (387 Views)

Re: Dimension export routine modification

12-09-2012 07:32 PM in reply to: Hallex

New excel sheet. We are trying to simplify our fab system so that we can export over all lengths of material and any holes that need to be punched to our tigerstop systems.

 

Thanks for any help you can offer.

Active Member
JoeMerry
Posts: 9
Registered: ‎12-07-2012
Message 5 of 17 (367 Views)

Re: Dimension export routine modification

12-10-2012 06:43 AM in reply to: Hallex

I loaded the library then XLEXPDIM after executing the XDIM command and specifing Sheet1 it locked up my autocad. I know I didnt provide some important information i.e. i am running AutoCAD Mech 2010 with excel 2010.

*Expert Elite*
Hallex
Posts: 1,569
Registered: ‎10-08-2008
Message 6 of 17 (354 Views)

Re: Dimension export routine modification

12-10-2012 11:59 AM in reply to: JoeMerry

Try attached code to write to newly created workbook,

maybe it will work on your end, all tested on A2010

and  Excel 2007 (student release)

_____________________________________
C6309D9E0751D165D0934D0621DFF27919
Active Member
JoeMerry
Posts: 9
Registered: ‎12-07-2012
Message 7 of 17 (350 Views)

Re: Dimension export routine modification

12-10-2012 12:23 PM in reply to: JoeMerry

; error: no function definition: XLGETAPP

 

This is the error I am receiving....

Active Member
JoeMerry
Posts: 9
Registered: ‎12-07-2012
Message 8 of 17 (349 Views)

Re: Dimension export routine modification

12-10-2012 12:29 PM in reply to: Hallex

Sorry,

 

I didnt load the lib first...seems to work really well.

I know i am pushing the "help" envolope but is there any way to make it use the column to the right of the first pull of numbers? i.e. If i run it once it put that set of numbers in column  A and if i pull a second time it adds those numbers to column B.

 

Thanks for a everything you have done!

*Expert Elite*
Hallex
Posts: 1,569
Registered: ‎10-08-2008
Message 9 of 17 (346 Views)

Re: Dimension export routine modification

12-10-2012 12:54 PM in reply to: JoeMerry

Please, upload Excel file in 2007 format to see what you exactly need,

just a few rows for imagination only

_____________________________________
C6309D9E0751D165D0934D0621DFF27919
Active Member
JoeMerry
Posts: 9
Registered: ‎12-07-2012
Message 10 of 17 (343 Views)

Re: Dimension export routine modification

12-10-2012 01:11 PM in reply to: Hallex

Hallex,

 

07 and 2010 should both be in .xlsx format but i have dropped it down to a .xls file just to make sure its what you need. The list of number is pure fiction just typed them in real fast but you should be able to get the jest of what i am shooting for at this time.

 

Thanks.

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.