Prev: COleException 0x80010105 MSWord Automation
Next: Word macro based on following text
From: Jane Jane on 7 May 2010 02:38
I have a Requirements Specification template with a number of different
tables. Some tables require numbering for the rows with a specific style eg
in the Business Rules tables users can click a button to apply/renumber all
rows with the style of BusRule. Each number requires a specified prefix eg
MR23-001, MR23-002 etc

(The reason for this is that at some stage the numbering will be "locked
down" as testers start using them so any additional business rules that need
to be inserted in the table are assigned the next number in the series
regardless of where it is inserted - so numbering may go 001, 002, 015, 003,
004 etc)

This was all working beautifully as the originally required numbering was
sequential throughout the entire document. I had a DocVariable set up for
the prefix which the user could update through a dialog box if required and
that prefix was applied to all the numbers.

This has now changed in that the sequential numbering ONLY applies to the
current table and that table must have a unique prefix for the number. I am
unsure of how to store/hold the prefix for each of the tables. I was
thinking that the easiest way may be to just include the required prefix in
the table heading somewhere eg [MR23] .

Any suggestions?

tks
Jane
From: Doug Robbins - Word MVP on 7 May 2010 03:45
I would use a macro containing the following code to create the numbers in a
table. Before the document is finally locked down, you would just run it
again if a row was inserted or deleted and it would re-insert the numbers.

The macro asks you for the prefix to be used for that table and then inserts
numbers into the cells of the first column of the table with that prefix
followed by a hyphen and then numbers in the format 001, 002, 003, etc.
starting with the second row of the table.

Dim i As Long
Dim prefix As String
prefix = InputBox("Enter the prefix to be used for this table.")
With Selection.Tables(1)
For i = 2 To .Rows.Count
.Cell(i, 1).Range.Text = prefix & "-" & Format(i - 1, "000")
Next i
End With


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"Jane" <Jane @discussions.microsoft.com> wrote in message
news:89BD96A2-3530-4973-B196-18630F97B81E(a)microsoft.com...
> I have a Requirements Specification template with a number of different
> tables. Some tables require numbering for the rows with a specific style
> eg
> in the Business Rules tables users can click a button to apply/renumber
> all
> rows with the style of BusRule. Each number requires a specified prefix
> eg
> MR23-001, MR23-002 etc
>
> (The reason for this is that at some stage the numbering will be "locked
> down" as testers start using them so any additional business rules that
> need
> to be inserted in the table are assigned the next number in the series
> regardless of where it is inserted - so numbering may go 001, 002, 015,
> 003,
> 004 etc)
>
> This was all working beautifully as the originally required numbering was
> sequential throughout the entire document. I had a DocVariable set up for
> the prefix which the user could update through a dialog box if required
> and
> that prefix was applied to all the numbers.
>
> This has now changed in that the sequential numbering ONLY applies to the
> current table and that table must have a unique prefix for the number. I
> am
> unsure of how to store/hold the prefix for each of the tables. I was
> thinking that the easiest way may be to just include the required prefix
> in
> the table heading somewhere eg [MR23] .
>
> Any suggestions?
>
> tks
> Jane

From: Jane on 11 May 2010 00:14
Thank you Doug. I could not seem to get access to any postings on this site
on Monday so managed to potter along on my own :-)

I decided to go with having the prefix included in the Header of the colum
in the format [XXX99] for a few reasons rather than prompt for the prefix to
be entered each time.

I also have the macro rippling through the table to find the greatest
assigned number and allocate the next one in the series to the row where the
cursor is positioned (providing it has no number already and is the correct
style). This I will use after the document is "locked down"

Jane

"Doug Robbins - Word MVP" wrote:

> I would use a macro containing the following code to create the numbers in a
> table. Before the document is finally locked down, you would just run it
> again if a row was inserted or deleted and it would re-insert the numbers.
>
> The macro asks you for the prefix to be used for that table and then inserts
> numbers into the cells of the first column of the table with that prefix
> followed by a hyphen and then numbers in the format 001, 002, 003, etc.
> starting with the second row of the table.
>
> Dim i As Long
> Dim prefix As String
> prefix = InputBox("Enter the prefix to be used for this table.")
> With Selection.Tables(1)
> For i = 2 To .Rows.Count
> .Cell(i, 1).Range.Text = prefix & "-" & Format(i - 1, "000")
> Next i
> End With
>
>
> --
> Hope this helps.
>
> Please reply to the newsgroup unless you wish to avail yourself of my
> services on a paid consulting basis.
>
> Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
>
> "Jane" <Jane @discussions.microsoft.com> wrote in message
> news:89BD96A2-3530-4973-B196-18630F97B81E(a)microsoft.com...
> > I have a Requirements Specification template with a number of different
> > tables. Some tables require numbering for the rows with a specific style
> > eg
> > in the Business Rules tables users can click a button to apply/renumber
> > all
> > rows with the style of BusRule. Each number requires a specified prefix
> > eg
> > MR23-001, MR23-002 etc
> >
> > (The reason for this is that at some stage the numbering will be "locked
> > down" as testers start using them so any additional business rules that
> > need
> > to be inserted in the table are assigned the next number in the series
> > regardless of where it is inserted - so numbering may go 001, 002, 015,
> > 003,
> > 004 etc)
> >
> > This was all working beautifully as the originally required numbering was
> > sequential throughout the entire document. I had a DocVariable set up for
> > the prefix which the user could update through a dialog box if required
> > and
> > that prefix was applied to all the numbers.
> >
> > This has now changed in that the sequential numbering ONLY applies to the
> > current table and that table must have a unique prefix for the number. I
> > am
> > unsure of how to store/hold the prefix for each of the tables. I was
> > thinking that the easiest way may be to just include the required prefix
> > in
> > the table heading somewhere eg [MR23] .
> >
> > Any suggestions?
> >
> > tks
> > Jane
>
> .
>
 | 
Pages: 1
Prev: COleException 0x80010105 MSWord Automation
Next: Word macro based on following text