B
billSBS
I am using forms in word2003 to create Report Cards. All the tables have the
same fields with the same formfield names. I need to run macros on some of
the fields.
I have used absolute cell referencing such as:
' Row4, Col2 is the location of the field- Comment
ActiveDocument.Tables(y).Cell(4, 2).Range.Text = CurrentComment
but it deletes the field and replaces it with Protected (uneditable)text.
So I manually renamed each Comment field Comment## where ## is the table
number.
All works OK with CASE structure. Ex:
Case 7
ActiveDocument.FormFields("Comments7").Result = CurrentComment
But the user can specify the number of tables needed so I need the renaming
to be automatic. And there are other fields that need macros.
Is manually renaming all macro-controlled fields the only solution?
Thanks
same fields with the same formfield names. I need to run macros on some of
the fields.
I have used absolute cell referencing such as:
' Row4, Col2 is the location of the field- Comment
ActiveDocument.Tables(y).Cell(4, 2).Range.Text = CurrentComment
but it deletes the field and replaces it with Protected (uneditable)text.
So I manually renamed each Comment field Comment## where ## is the table
number.
All works OK with CASE structure. Ex:
Case 7
ActiveDocument.FormFields("Comments7").Result = CurrentComment
But the user can specify the number of tables needed so I need the renaming
to be automatic. And there are other fields that need macros.
Is manually renaming all macro-controlled fields the only solution?
Thanks