Hi everyone,
Does anyone care to help me find the best solution to link object properties into excel cells?
I believe the best way is through VBA but unfortunately I don't have spare time to learn this language, so if someone could spare some tips how I achieved this it would be great.
I already read this from Jon:
But of course I didn't manage to continue as the sample give us only the first steps. This is for the illuminated ones.
I also present the same question on programming forum but until now I didn't receive any answer.
http://communities.bentley.com/products/programming/f/343380/t/115869
I don't want to use the new table object, because I want to use filters, and others elements in my table.
Thanks for all the help that anyone can give.
Regards
José
Unknown said:Information can be extracted from the drawing properties to a spreadsheet but not vice versa
Yes: making a general-purpose two-way communications channel is hard. Relational database technology provides this capability, but under constrained conditions that don't meet José's request.
If you constrain your requirement, then things get easier. For example, FlexiTable™ can be used to exchange tag data with an Excel worksheet. The exchange is bidirectional. However, it requires that your Excel worksheet has Excel named ranges. The named ranges (i.e. an Excel schema) correspond to MicroStation tag data definitions (i.e. a MicroStation schema).
Unfortunately, few people are aware of Excel named ranges, few people are familiar with MicroStation tag definitions, and still fewer people understand both together. Consequently, not many people are using FlexiTable's capabilities other than in highly constrained circumstances, such as drawing title blocks.
Regards, Jon Summers LA Solutions
Jon I don't think I'm describing what I need in clear. I want a single way link element properties to present data in my excel spreadsheet. Maybe people read this and think why don't use new table element from CE and link element information on the table and then export that to excel? Well, I need to use filters. So everytime I would do a element change, my table from Microstation would update, but then I would need to export to excel and configure again everything. Too much work this way. I need to link excel cell to catch the element information that I need from Microstation. Automatically or not. If I need a button to refresh the data that would be very nice also because I wouldn't need to check every item again. Regards.
Unknown said:I need to link Excel cell to catch the element information that I need from MicroStation
Can you provide an example of element information in MicroStation and how you would like those data to appear in Excel?
Unknown said:We badly need a simple Import and export utility to support the new element properties provided by Item Types
This thread has evolved and its dicussions are diverging. We now have two different topics...