Bogdan Ciocan Posted November 4, 2021 Share Posted November 4, 2021 Hello, with new Worksheet Functions in VW 2022 i hoped to extract the actual amount of Objects, in may case Symbols from a project, in a record field, but not necessarily. What I'm trying to do is to write these amounts back to an excel worksheet via ODBC. Has anyone done this before or do you have any idea on how i could do this? Thank you, Best regards Bogdan Quote Link to comment
Pat Stanford Posted November 7, 2021 Share Posted November 7, 2021 I don't think you need any of the new functions to do this. =Count should be able to do what you want. =COUNT(((T=SYMBOL))). Will return the total number of symbols placed in the drawing area of the file. =COUNT(((S='Symbol-1'))) Will return the number of symbols named 'Symbol-1' I don't have any idea about doing the OBDC export. If you are on Mac, I am not sure the OBDC of Mac Excel works with VW. You might be able to use the Data Manager to store the values into a record attached to a proxy object (maybe a locus on a layer reserved for this purpose) with a record attached that could update the OBDC file. Quote Link to comment
Bogdan Ciocan Posted November 9, 2021 Author Share Posted November 9, 2021 Hi @Pat Stanford, the reason is to compare the used Symbols ( in our case Materials ) from a Project with the available amount within a specific period of time from our warehouse. But I'm not able to send the actual count of Symbols to Excel, other then data form record format. I know that the values form record format are defaults, but at the moment i don't see another way. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.