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
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.
Access a broad range of knowledge to help get the most out of your products and services.
Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.
Upgrading to a 2015 product? Make sure to check these out 1st!