VBA, Need help w/Protected document with form text fields and check boxes

Need help w/Protected document with form text fields and check boxes

Author	Message
Scott McCulloug #1 / 3	Need help w/Protected document with form text fields and check boxes Using Word 97 Using VBA, I am trying to run a macro from Excel that will place Excel cell values in form fields in a protected word document and also select or de-select a check box on the form depending on the value of a certain Excel cell. Because the document is protected, it doesn't want to cooperate. Is there a way to insert data into the form fields and checkboxes of a protected document? What is the correct syntax? Any help would be greatly appreciated. Scott McCullough
Tue, 01 Apr 2003 03:00:00 GMT

Cindy Meister -WordMVP #2 / 3	Need help w/Protected document with form text fields and check boxes Hi Scott, Quote: > Is > there a way to insert data into the form fields and checkboxes of a > protected document? o_doc.FormFields("FieldName").Result = myStringVar o_doc.FormFields("CheckboxName").Checkbox.Value = True 'or False Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister http://www.mvps.org/word http://go.compuserve.com/MSOfficeForum This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-)
Fri, 04 Apr 2003 03:00:00 GMT

Charles Kenyo #3 / 3	Need help w/Protected document with form text fields and check boxes Scott, Take a look at the template you can download from Joseph Freedman's site http://jjfreedman.homestead.com/field_template.html It has some excellent code on protecting / unprotecting a document and resetting to the original condition. -- Charles Kenyon Word New User FAQ & Web Directory: http://www.addbalance.com/word Legal Users Guide (modified) http://www.addbalance.com/usersguide --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. Quote: > Hi Scott, > > Is > > there a way to insert data into the form fields and checkboxes of a > > protected document? > o_doc.FormFields("FieldName").Result = myStringVar > o_doc.FormFields("CheckboxName").Checkbox.Value = True 'or False > Cindy Meister > INTER-Solutions, Switzerland > http://homepage.swissonline.ch/cindymeister > http://www.mvps.org/word > http://go.compuserve.com/MSOfficeForum > This reply is posted in the Newsgroup; please post any follow > question or reply in the newsgroup and not by e-mail :-)
Sat, 05 Apr 2003 03:00:00 GMT

Page 1 of 1

[ 3 post ]