ASE, SQL, OLE, ADE

ASE, SQL, OLE, ADE

Reply
Contributor
seregadushka
Posts: 15
Registered: ‎01-29-2012
Message 1 of 4 (639 Views)

Reverse system of link Excel-AutoCAD

639 Views, 3 Replies
01-29-2012 09:09 AM

Now, this communication system is working badly. I'll try to explain

1 Be sure to need the ability to create macros and bind to the buttons or keys. Saychas due to a general window "paste special-relationship-sheet excel" and "paste special-relationship-object autocad" can not do this. You just have to divide into different windows. This is used by 200 times a day, every time it is impossible to use menu.

2. Established relationship "special insert-link-object autocad" can not be edited in practice. Usually, all links in the drawing have the same font, style, etc.

3, Table styles and text styles are not related

Often after the update links, which are single-cell table, table styles vozbraschayutsya with the standard, and have to start all over again. No need to display the names of rows and stobtsov in relationships - they close nearby objects, and make it impossible for their joint selection.

4, "The properties of the format" does not work for "a special insert-link-object autocad"
5. The default connection should be editable, but not locked. During configuration, it has to unlock a lot of time.

6. It might be better to create a new "communication style", prone to edit all the links in the drawing, to give and change their common properties.
 
 
 

 

Contributor
seregadushka
Posts: 15
Registered: ‎01-29-2012
Message 2 of 4 (635 Views)

Re: Reverse system of link Excel-AutoCAD

01-29-2012 09:18 AM in reply to: seregadushka

A little more, what I have been suffering for nearly 3 years

 

Imagine that the drawing is 100 "special insert-link-object autocad" with the file path1/file1.xlsx

And I needed to change the location and name of the file on path2/file2.xlsx

 

Try to solve this problem

Contributor
seregadushka
Posts: 15
Registered: ‎01-29-2012
Message 3 of 4 (628 Views)

Re: Reverse system of link Excel-AutoCAD

01-29-2012 12:17 PM in reply to: seregadushka
 
Contributor
seregadushka
Posts: 15
Registered: ‎01-29-2012
Message 4 of 4 (627 Views)

Re: Reverse system of link Excel-AutoCAD

01-29-2012 12:40 PM in reply to: seregadushka

It is necessary to give more information.

 

The value of 41.8 in the second figure is the original. Its takes a cell named "urojaynost" from the third file, divide by 10.

The cell contains $J1 "[PerspPortyanko.xlsx]Sheet1!" This file name and sheet.
The purpose of the function of indirect forwarding =INDIRECT(CONCATENATE ($ J1;"urojaynost")) to result from a direct link [PerspPortyanko.xlsx]Sheet1!"Urojaynost", which is the number of 4.18.

 

This is the result, which should be transferred and AutoCAD.
Communication with Excel, as an object of autoCAD, gives an error #REF.
I apologize for such a complex example, it is difficult to understand without a bottle.

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Are You Going To Be @ AU 2014? Feel free to drop by our AU topic post and share your plans, plug a class that you're teaching, or simply check out who else from the community might be in attendance. Ohh and don't forgot to stop by the Autodesk Help | Learn | Collaborate booths in the Exhibit Hall and meet our community team if you get a chance!