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.
Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register
Start with some of our most frequented solutions to get help installing your software.