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: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.
Regards, Jon Summers LA Solutions
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)
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)
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
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
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....)
edit: attached as zip as otherwise forum renamed files and macro couldn't find the correct dialog.
table-v8i.zip
Answer Verified By: Lorys