import quote from foglio excel

[goccia]

Hello.
I created a dwg file with 2d drawing and parametric quotas.
I would now like to be able to change these quotas from the outside, linking them to a excel sheet.
I tried to slew on the autocad tables, but I just managed to import the tables in the worksheet, without any links with the odds, as it affects me.
can you tell me how to create this link quota_autocad <-> cells_excel?

 

[Tristan]

I doubt that autocad is capable of doing this. with inventor instead I'm sure you can

 

[rpor66]

inventor si e autocad liscio no? excel solves the lack.
in the sheet you find two buttons, list and refresh parametric; the first writes the variables created in the dwg in excel, excluding those containing formulas, the other withdraws the values from excel and overwrites the variables in autocad thus allowing to change the parametric design.
you can avoid using listparametrics, just manually write the names of the variables you want to change, add the value and refresh.
the file has as reference of the autocad library 2018, provide you according to your version to change it.

I threw it down, if you have any problems, ask.

greetings

 

[goccia]

How does a macro take data from autocad?


list works, refresh no.

 

[goccia]

This is what I would like to do:
I do not work with inventor because the mechanism will remain in 2d, and with inventor, if I do not create a solid for every part in the table I see nothing.
beyond all I do not know how to create vectors that change according to the movements of the engine member, the disc crank.

 

[goccia]

Forgive me for the following post rpor66, but I handcuffed a bit on your file and I noticed the following:
list parametric takes variables (ok works)
refresh parametric overwrites the parametric variables of autocad only the first time, but returns the above-posted error.
Is there a way to always make it work?
Is it hard to give me directions to break the code? (years ago I knew a little vb4.0).

 

[rpor66]

revised and correct, try it.
As soon as I have a little time, I'll do a handbook and the place.
Hi.

 

[goccia]

first of all thank you for this time you are dedicating.. .
Then...how does the ang1 variable not result?
It's important to be able to change the crank angle.

 

[goccia]

a request: can you make sure that only some variables are imported?
this because speed and acceleration values must be measured by excel after upgrading from geometry and
then I must be returned.

then:
1. premo list and get the list of variables (functions, compliments)
2. modify some variables
3. the other unmodified and that were a consequence of the previous geometry, will be passed, which should not happen.

ideal is therefore to be able to choose variables to import or refresh and make sure that list and refresh write in different cells or sheets.

 

[goccia]

ang1 does not take it because it is equal to 0 and in the code you wrote that it must be different from 0.

 

[rpor66]

a request: can you make sure that only some variables are imported?
this because speed and acceleration values must be measured by excel after upgrading from geometry and
then I must be returned.

then:
1. premo list and get the list of variables (functions, compliments)
2. modify some variables
3. the other unmodified and that were a consequence of the previous geometry, will be passed, which should not happen.

ideal is therefore to be able to choose variables to import or refresh and make sure that list and refresh write in different cells or sheets.

1) correct, if it is a number is imported, before it was 0 the discarded.
2 and 3) change the variables do it on column c (new values), only the cells containing values will return in autocad, the empty ones will not.

if the values to be written in the column are resulting from calculation, add to the program the part of software that takes the data from column b, processes them and writes them in column c if different.

Hi.

 

[rpor66]

software, example design, manual use and software description

 

[goccia]

Good job. can you make sure that if on autocad, working, I add another variable and then I refresh, this on excel stands at the end and not in between? (this is because I get all the formulas in the sheet).

 

[rpor66]

do not use listparametric, simply add the name of the column a variable, set the value in column c and use only refresh to change the value.

 

[goccia]

I can't do this because every time I pass a new angle geometry changes, so the new odds and I have to take these.

 

[rpor66]

ok, modificato software e manuale.

 

[goccia]

I missed the answer post, thank you infinitely.

 

[goccia]

of 4 variables takes only two :frown:

 

[rpor66]

It is not that only reads two, reads only those that have as value a number, ang1 is a number + variable.
at the moment I can't read the variables users in parameter, so the value to be added in ang1 you have to manage it in excel.
practically, the value of the variable variation_angular eliminates it from autocad, the ang1 tops in excel.

 

[Matteo1993kla]

Hello everyone, I make complents to the creator of the basic visual “linkparametric” is brilliant! I write to ask for help on the program. is it possible to insert even quotas with decimals?? because this version I have does not allow me to insert them!