Linking Record formats to referenced Excel worksheets
I am starting to explore the new excel referencing in Vectorworks 2024. Am I correct in thinking that only 'dumb' / self contained worksheets can be referenced, ie if we have a worksheet with database rows and or fields that are reading information from record formats there is no way to link them to an excel file? This seems to limit the benefits of this new feature significantly if the worksheet can't take advantage of the data contained within the vectorworks file? Or am I missing how to do th
I watched the Vectorworks University video and, no offense to Vectorworks, but big yikes! Sometimes I wonder if they think we get paid by the click.
@Maury Jensen contacted me earlier this week about this topic, and I sat down and wrote him a menu command to do this. The menu command launches a dialog box letting you choose a Worksheet, a Record to link it to, and a Field to use as a key. When you press OK, it will go through the chosen Worksheet line by line and scour the drawing
