Demosthine
09-28-2008, 11:45 AM
Hey Everyone.
For work, I have a report that I do regularly on my Blackberry Phone. I have a simple spreadsheet that has three columns. Column B is associated with the FormField Name in a Word Document and Column C is the value I want to put into the FormField.
I have come across a limitation when I attempt to assign the Excel values to the Word FormField. It causes an error if I am assigning more than 256 characters.
I have found a Thread [Thread=22190]here[/ThreadID] that relates to the FormField's Name being too long and it is recommended to use Bookmarks. When I try this by assigning the Excel value to Bookmarks(FieldName).Range.Text, it errors out again. I would assume this is because the document is protected.
Is there a way around this while keeping the document protected?
Thanks.
Scott
For work, I have a report that I do regularly on my Blackberry Phone. I have a simple spreadsheet that has three columns. Column B is associated with the FormField Name in a Word Document and Column C is the value I want to put into the FormField.
I have come across a limitation when I attempt to assign the Excel values to the Word FormField. It causes an error if I am assigning more than 256 characters.
I have found a Thread [Thread=22190]here[/ThreadID] that relates to the FormField's Name being too long and it is recommended to use Bookmarks. When I try this by assigning the Excel value to Bookmarks(FieldName).Range.Text, it errors out again. I would assume this is because the document is protected.
Is there a way around this while keeping the document protected?
Thanks.
Scott