How to renumber multiple drawing numbers in a file location containing multiple dgn files.

The easiest way (IMO) to do this is to have MS Connect installed to just handle the sheet numbering.  That way you can utilize the built-in Sheet Indexer which actually does this sort of thing.  If you are hard pressed on staying with MSv8 for this process, off the top of my head (never actually attempted to do this) will require the following things:

• Make sure to use Sheet Name sheet property for the page number, not the Sheet Number property...explained below
• Create a cell that utilizes a field that reads the sheet's Sheet Name property
• Replace the number that you have in the border (your image) with the cell that will auto-update based on the sheet's Sheet Name property
• Create a macro inside MicroStation (MVBA) that reaches out to the Excel file to update the Sheet Name property based on the file name
• Create a Batch Process that will run the macro against the DGN files to update them based on the Excel file

As for the first comment...the Sheet Number inside of MSv8 is really a Sheet Sequence number instead of a sheet number.  The difference between the fields?  The Sheet Name can be alphanumeric whereas the Sheet Number/Sequence is an integer...no letters allowed.  This may not really be a factor with your organization, but at some point you will need to move to MSCE (like everyone else) and they actually fixed the name of these entries inside of MSCE.

For bullet #2:

When creating the cell, you need to change the cell/model to a sheet model.  Then use the Place Text command...

Once you hit OK, this allows you to place the field in the cell model.

Now, wherever you place this cell inside of a sheet model, it will update (based on your field update settings) to match whatever the sheet model's Sheet Name is set to.

Sean

The easiest way (IMO) to do this is to have MS Connect installed to just handle the sheet numbering.  That way you can utilize the built-in Sheet Indexer which actually does this sort of thing.  If you are hard pressed on staying with MSv8 for this process, off the top of my head (never actually attempted to do this) will require the following things:

• Make sure to use Sheet Name sheet property for the page number, not the Sheet Number property...explained below
• Create a cell that utilizes a field that reads the sheet's Sheet Name property
• Replace the number that you have in the border (your image) with the cell that will auto-update based on the sheet's Sheet Name property
• Create a macro inside MicroStation (MVBA) that reaches out to the Excel file to update the Sheet Name property based on the file name
• Create a Batch Process that will run the macro against the DGN files to update them based on the Excel file

As for the first comment...the Sheet Number inside of MSv8 is really a Sheet Sequence number instead of a sheet number.  The difference between the fields?  The Sheet Name can be alphanumeric whereas the Sheet Number/Sequence is an integer...no letters allowed.  This may not really be a factor with your organization, but at some point you will need to move to MSCE (like everyone else) and they actually fixed the name of these entries inside of MSCE.

For bullet #2:

When creating the cell, you need to change the cell/model to a sheet model.  Then use the Place Text command...

Once you hit OK, this allows you to place the field in the cell model.

Now, wherever you place this cell inside of a sheet model, it will update (based on your field update settings) to match whatever the sheet model's Sheet Name is set to.

Sean

But it looks like he is using model space and title block cell or title block ref file not sheet model...

Christian the way I do it in V8i is through tags copied into the active file from the ref file title block second model at time of placement, then I have custom built vba's to  import and export from excel to dgn and from dgn to excel... I paid for these from Caddpro by Adam Lambert in Australia very inexpensive and even works with acad files in a msnt session my acad colleagues at work use it  in msnt to do all their acad title blocks... I'm not good at vba so it paid for itself  first project 300 plus drgs... you can google  Caddpro in youtube to see demos.. it works in non graphic mode so its extremely  faster than manually opening each file and making the changes, plus with excel you get to use  series fills and equations etc much easier than typing...

other  companies make similar products like Flexitable by La Solutions UK and

Axiom tools title block tool or manager ( this one was very expensive  compared to Caddpro)

It very much depends on how your title block is added to your drg files...