Could somebody at Bentley please update the still delivered ms basic Macro "table.bas" to a VBA macro, in V8i we cant easily create tables like our acad brothers, this little tool does a great job but it needs to be updated to VBA any takers....?
Unknown said:In V8i we can't easily create tables
FlexiTable™ solves that omission! It provides quite a few other tools as well.
Regards, Jon Summers LA Solutions
Unknown said: Lorys In V8i we can't easily create tables FlexiTable™ solves that omission! It provides quite a few other tools as well.
Lorys In V8i we can't easily create tables
Yes Flexitable is an excellent product with loads of features ... however as Basic was said to be deprecated even when v8i was released, bentley provided Table.bas FREE as part of the install V8i ss3 package .. I believe they should release or provide a vba version or equivalent tool ... the old tool still works but under strict conditions no bylevel anything or overrides to be used at all or it will give an overflow error, this may have mislead some users to think it doesnt work.. but this is still the same code we had back in Version J...( well thats when I first saw it could have been MS95 .. whichever came first with it...)
Lorys
Started msnt work 1990 - Retired Nov 2022 ( oh boy am I old )
But was long time user V8iss10 (8.11.09.919) dabbler CE update 16 (10.16.00.80)
MicroStation user since 1990 Melbourne Australia.click link to PM me
Unknown said:Bentley provided Table.bas FREE as part of the install V8i ss3 package
Bentley Systems may provide table.bas with MicroStation, but it is not 'free'. It's part of a software product for which your employer has purchased a license. It's no more 'free' than, say, the cell dialog is 'free'. To put it another way, if you were to advertise table.bas (or a modified version of it) as your table generator for MicroStation, Bentley Systems might take a legal action against you for violating their copyright, license agreement or both.
Unknown said:The old tool [table.bas] still works but under strict conditions no bylevel anything or overrides to be used at all
As I may have mentioned before, MicroStation BASIC omits a lot of functionality that would make it play well with the V8 generation. In particular, it knows nothing about named levels. Nor does it comprehend level overrides. That's one reason why MicroStation VBA, which does know about named levels and level overrides, is a much better choice for in-house programming.
Unknown said:I believe [Bentley Systems] should release or provide a vba version
Well, MicroStation CONNECT includes reports and tables. The table functionality in CONNECT is way better than BASIC or VBA could provide. However, the technology behind it is not compatible with the V8 generation, so don't expect Bentley Systems to back-port tables to V8i.
ok its not free but its included in the package for no extra cost , however as I tried to say it was obsolete when it was supplied ... no matter..
As regards to CE , I dont feel its good enough to use in production office use yet , there seems to be too many posts for CRs and defects being posted here ... so we will wait a little while longer and suffer V8i ... there is still a very large user base using v8i I wonder if we out number the CE users...?
But MSBASIC works in v8i why you need it updated? Or you would like to edit tables created in CONNECT edition?
>the old tool still works but under strict conditions no bylevel anything or overrides to be used at all or it will give an overflow error
This can be easy fixed just by changing variable declaration "Dim saveStyle as Integer" to "Dim saveStyle as Long" as bylevel(-1) for macro is equal to value 2147483647 which doesn't fit in integer variable(-32768 to 32767) that is why overflow error. Strange that such old macro which doesn't work is still included in v8i installation but it is not a surprise as MSBasic documentation also is full of examples which just don' t work.
edit: attached as zip as otherwise forum renamed files and macro couldn't find the correct dialog.
table-v8i.zip
Answer Verified By: Lorys
Unknown said: But MSBASIC works in v8i why you need it updated? Or you would like to edit tables created in CONNECT edition? >the old tool still works but under strict conditions no bylevel anything or overrides to be used at all or it will give an overflow error This can be easy fixed just by changing variable declaration "Dim saveStyle as Integer" to "Dim saveStyle as Long" as bylevel(-1) for macro is equal to value 2147483647 which doesn't fit in integer variable(-32768 to 32767) that is why overflow error. Strange that such old macro which doesn't work is still included in v8i installation but it is not a surprise as MSBasic documentation also is full of examples which just don' t work. (Please visit the site to view this file) (Please visit the site to view this file)(Please visit the site to view this file)
(Please visit the site to view this file)
(Please visit the site to view this file)(Please visit the site to view this file)
First it wouldnt work with with overrides and or bylevel etc settings being active.
Secondly because it was basic if I asked or mention if anyone would fix as basic to stay basis.. I would undoubtedly be flamed by at least two of our most frequent posters as has happened every time I have offered basic as a solution or alternative to solve a problem or free tool..
I have acquired many public domain basic programs as well as made quite a few custom ones myself over 25 years, and still use them in v8i..
I'm trying to wean myself of basic in favour of vba, to prepare for the inevitable day when we are compelled to use CE with much kicking and screaming .... I just dont like the ribbon bar in anything I 've come across ie MS office , Acad etc....I really wish it was optional to use it........ oh back to topic
Thanks for taking a look... cant wait to use the updated tool ... I have one client that insists on tables being text not excel.... the table bas is very good at getting the data out of csv ( ex excel tables....)
Doesnt work as expected, gives error about dialog whose id is 1
doesnt give you the option to have the dialog panel with all the choices for column widths, sizes,colours etc
Unknown said:I have one client that insists on tables being text not excel.
FlexiTable™ creates tables using MicroStation graphic elements, including text elements for words & numbers. That provides excellent quality graphics that print to PDF or paper with full fidelity. That contrasts sharply with the poor quality of a linked Excel spreadsheet.
Unknown said:... table.bas is very good at getting the data out of csv ( ex excel tables....)
It does a good job if the input text is literally unquoted strings separated by commas...
one,two,three,...
However, it doesn't accept anything other a comma as the field delimiter. That is, you can't use a tab, say, or semi-colon to separate the fields. It will fail also if the CSV contains quoted text with an embedded comma (e.g. "1, High Street").
FlexiTable reads Excel files directly, so there's no need to export from Excel to CSV before reading the CSV in MicroStation.
Unknown said:I'm trying to wean myself of basic in favour of VBA
Good plan! With the problems you've found with table.bas, I hope that you're beginning to appreciate the recommendation to prefer MicroStation VBA to BASIC.