table builder

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

  • 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...?

     

    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 

  • I'm pretty sure V8i outnumbers CE by quite a lot.
  • 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)

    I  was asking for it to be updated to VBA  for two reasons,

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

    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:

    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