• This forum is the machine-generated translation of www.cad3d.it/forum1 - the Italian design community. Several terms are not translated correctly.

macro per collegare excel e autocad

  • Thread starter Thread starter atorchia
  • Start date Start date
atorchia said:
uses 2000 in Italian
Click to expand...
I have no way to verify why autocad 2000 and out of range from mo, I tried with 2008,2009 and 2010 and it works all, try so there are two files, tell him to try with these....

p.s. only work for 2000 of course. ....

If you're in trouble, ask him to type acadver in autocad and tell me what he says?
 

Attachments

I'm aurel.
I'd like to serve myself...
but we use autocad lt 2009
and excel2003.
It's not right.
Thank you.
 
shape,
Thank you for helping me with this disusion, I treasured your macro in vba, but I would like to know another thing.
I have a set of blocks with attributes that delimite a series of rooms within a dozen buildings scattered within an area, my "tag" block contains the number of the room the type of floor belonging to the building etc., I can export and data of the attributes in a file of excel, and I can with your vba to zoom in near the room that contains the block with the attributes at this point comes the question

can keep data updated in excel file by changing data in autocad blocks?
and still it is possible to keep the attributes updated within autocad blocks by changing the rows of the file in excel?

if you well otherwise I have to put them to make a program in lisp through the aolisp routines that are able to develop and I put more than a week of time

thanks in advance and hello from acitano
 
acitano said:
shape,
Thank you for helping me with this disusion, I treasured your macro in vba, but I would like to know another thing.
I have a set of blocks with attributes that delimite a series of rooms within a dozen buildings scattered within an area, my "tag" block contains the number of the room the type of floor belonging to the building etc., I can export and data of the attributes in a file of excel, and I can with your vba to zoom in near the room that contains the block with the attributes at this point comes the question

can keep data updated in excel file by changing data in autocad blocks?
and still it is possible to keep the attributes updated within autocad blocks by changing the rows of the file in excel?

if you well otherwise I have to put them to make a program in lisp through the aolisp routines that are able to develop and I put more than a week of time

thanks in advance and hello from acitano
Click to expand...
I'm sorry I'm late, but I've been a little bit taken...

then to export data to excel from attributes no problem... keep updated the excel file to change the dwg... I think it is appropriate to reexport the data as it is from the modification.. .

fasten files from excel.. This is also piossible, but it is necessary to create a macro excel that to change the value open the dwg and update it.. I had done something like that before.. .

Of course the whole cmq is to be built ad hoc .. we say that export is the easiest thing. . .

It is a simple array of blocks and one of the attributes, the read data is written in an excel file creating or opening a base...

the connection between the two is a bit to think.. .
 
You don't have to apologize for the delay... Anyway go quiet thanks to the precious tips and I will keep you updated while I study a little too and when I have the free way from the customer I focus on the vba part of excel that is the one in which I pay a little!

hi from acitano
 
Shape said:
as required by the user deleted button and the line is activated by double_clicik on the line corresponding to the desidarated view.

entered confirmation message operation to avoid undesirable macro launches. Selecting yes follows, to cancel no

modified location columns
Click to expand...
Hi.
I wanted to ask if it was possible to see the programming language you used to make this macro. I'd be grateful, since I'm trying to learn how to program myself in the excel-acad environment.

Thank you.

mk
 
Hello, everyone!
I read you a lot and thank all the users who write in the forum.

I don't understand anything about vba (but I started studying! )
I did several tests with scripts, research and research with google,
But nothing, I'm at a dead point.

I am trying to connect an excel file with autocad:
I wish I could. connect the labels of the cards and some legends to a excel sheet.

I have 400 dwg files and related files to update and edit, change name.
I need an elastic structure that allows me to change the values of tags cambiando solo l'excel and automatically update all *.dwg files

I have prepared my beautiful excel file with all necessary fields, carts with blocks with attributes, now I miss the next step: fill out the attributes of autocad blocks with excel values.

I know I ask too much, but in an ideal world:

I would like the value of the "dis1" block attribute within the file: "tav01.dwg" read the c file: processed list. xls/sheet ee/ searched in line 2 of this file the column "dis1" then in the column "filename" crossed the data "tav01.dwg" and returned the corresponding value.
View attachment 33022Is that too much to ask? Is it feasible?

I made some attempts using lisp to replace attributes and using data links managers, but I never got what I want.

What do you think?

Thank you in advance!
 
Okay, you can do it, I answered myself with the useful search:) :mixed:
http://www.cad3d.it/forum1/showthread.php?744-compilazione-cartiglio-automatica/page3
maubra said:
Hello, everyone!
I read you a lot and thank all the users who write in the forum.

I don't understand anything about vba (but I started studying! )
I did several tests with scripts, research and research with google,
But nothing, I'm at a dead point.

I am trying to connect an excel file with autocad:
I wish I could. connect the labels of the cards and some legends to a excel sheet.

I have 400 dwg files and related files to update and edit, change name.
I need an elastic structure that allows me to change the values of tags cambiando solo l'excel and automatically update all *.dwg files

I have prepared my beautiful excel file with all necessary fields, carts with blocks with attributes, now I miss the next step: fill out the attributes of autocad blocks with excel values.

I know I ask too much, but in an ideal world:

I would like the value of the "dis1" block attribute within the file: "tav01.dwg" read the c file: processed list. xls/sheet ee/ searched in line 2 of this file the column "dis1" then in the column "filename" crossed the data "tav01.dwg" and returned the corresponding value.
View attachment 33022Is that too much to ask? Is it feasible?

I made some attempts using lisp to replace attributes and using data links managers, but I never got what I want.

What do you think?

Thank you in advance!
Click to expand...
 
Bye to all,
with a vba expert colleague, reading around and copying and pasting we created a vba file that makes the wonderful magic of reading from excel and writing on autocad.

so I confirm that you can do it!

Unfortunately it has problems of versions of autocad, of vba libraries and one on all it puts a little to look for the blocks to be compiled because instead of looking only the blocks with attributes analyzes all the objects present in the drawing.

we are trying to make it a stable and easy-to-use program and then we will make more practical masks without having to open the dvb to change the path and name of the excel file or the dwg file path.

Unfortunately we learn little at a time, but we are confident as though a little slow, it works! ;)

Thank you all!
 
maubra said:
Bye to all,
with a vba expert colleague, reading around and copying and pasting we created a vba file that makes the wonderful magic of reading from excel and writing on autocad.

so I confirm that you can do it!

Unfortunately it has problems of versions of autocad, of vba libraries and one on all it puts a little to look for the blocks to be compiled because instead of looking only the blocks with attributes analyzes all the objects present in the drawing.

we are trying to make it a stable and easy-to-use program and then we will make more practical masks without having to open the dvb to change the path and name of the excel file or the dwg file path.

Unfortunately we learn little at a time, but we are confident as though a little slow, it works! ;)

Thank you all!
Click to expand...
I hope, if you want and do not want to make a commercial product, to share your work with the forum. ;-)
 
The idea was that plannerroad, but it also depends on my colleague.
Even if I'm not a programmer, I'm an opensource estimator.

I have been using autocad for 13 years operationally and an idea I have made of the functions that would serve such an instrument;)
for how I see autodesk should have implemented them for a long time!

We'll let you know.
Mauritius
 
can you connect autocad to excel as to outlook (I don't know, update a cartilage when you receive an email? ; send an email with a new revision?) or to word (I don't know ,modify a text of a specific when a new revision is issued? , changed a weight? ).
This is the implementation and is feasible with a minimum of hand, you can't claim that there is a function that runs your specific needs, which can be different from mine, and that of nmila users.
 
Hello pertenginering, I disagree!
changing tags in n autocad designs from an excel file is a banality that should be granted and managed simply by the program. It doesn't sound like science fiction.
It seems absurd to me to have a vba uncomfortable for something like that.
I'm a designer not a programmer.
autodesk makes programs to facilitate designers.
Such a function is the basis of design studies.
 
I'll give you reason but you have to know how to arrange and pull out the maximum with the tools you have available to be competitive and if a tool is there you have to learn how to use it if you want to come out.
You will see that in addition to the problem that you expose you will find solutions and optimizations also for other, it is not time lost.
:smile:
 

Forum statistics

Threads
44,997
Messages
339,767
Members
4
Latest member
ibt

Members online

No members online now.
Total: 0 (members: 0, guests: 0)
Back
Top