Visual LISP, AutoLISP and General Customization
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Dimension export routine modification

16 REPLIES 16
SOLVED
Reply
Message 1 of 17
JoeMerry
1664 Views, 16 Replies

Dimension export routine modification

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.

16 REPLIES 16
Message 2 of 17
Hallex
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
Message 3 of 17
Hallex
in reply to: JoeMerry

Well, rry from this attachment

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

load library then then XLEXPDIM.lsp

_____________________________________
C6309D9E0751D165D0934D0621DFF27919
Message 4 of 17
JoeMerry
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.

Message 5 of 17
JoeMerry
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.

Message 6 of 17
Hallex
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
Message 7 of 17
JoeMerry
in reply to: JoeMerry

; error: no function definition: XLGETAPP

 

This is the error I am receiving....

Message 8 of 17
JoeMerry
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!

Message 9 of 17
Hallex
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
Message 10 of 17
JoeMerry
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.

Message 11 of 17
Hallex
in reply to: JoeMerry

Hi Joe

Try revisited code, this is just slightly tested,

so let me knof how it will do the work

_____________________________________
C6309D9E0751D165D0934D0621DFF27919
Message 12 of 17
JoeMerry
in reply to: Hallex

Works fantastic! The only minor issue i see is that is places the numbers in decending order, largest to smallest. If that could be fixed in the routine it will be perfect, if not no biggie we can do it via excel.

 

Thanks a ton for all your effort!!!

 

Joe

Message 13 of 17
Hallex
in reply to: JoeMerry

Hi Joe,

Again show me file or picture coz I could not understand this good enough

Do you want to sort all the data by row or by column?

_____________________________________
C6309D9E0751D165D0934D0621DFF27919
Message 14 of 17
JoeMerry
in reply to: Hallex

Hallex,

 

The way you have it going horizontal across the screen is perfect (by rows). The example excel I sent you shows the largest to lowest numbers left to right. We discovered this morning that we need to list the smallest number first ascending to the largest. Smallest far left, largest far right. Opposite of what I showed in my example. Just need to reverse the order of placement in excel.

 

I do apologize for any confusion I am causing.

 

 

Message 15 of 17
Hallex
in reply to: JoeMerry

Well I added sort by row in there

see how it works

_____________________________________
C6309D9E0751D165D0934D0621DFF27919
Message 16 of 17
JoeMerry
in reply to: Hallex

Wonderful!!! Looks and work great Fixo....thanks a ton for your patience and energy.

Message 17 of 17
Hallex
in reply to: JoeMerry

Very glad if that helps to do your job

Happy coding Smiley Happy

 

~'J'~

_____________________________________
C6309D9E0751D165D0934D0621DFF27919

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report

”Boost