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
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