ASE, SQL, OLE, ADE

ASE, SQL, OLE, ADE

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

Reverse system of link Excel-AutoCAD

605 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 (601 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 (594 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 (593 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.

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.