Thread: [Solved] VBA Batch Find & Replace for all MSOffice extensions, to replace File Name and Content of the File
View Single Post
 
Old 09-11-2014, 03:41 AM
QA_Compliance_Advisor QA_Compliance_Advisor is offline Windows 7 32bit Office 2010 32bit
Advanced Beginner
  
Join Date: Jul 2014
Posts: 44
QA_Compliance_Advisor is on a distinguished road
Default Replace entry list in dropdown
Quote:
Originally Posted by gmaxey View Post
The forum is full of examples of batch processing files. For the dropdown piece, it would probably be easier to just clear the existing list and fill it with a new list. The following code assumes a content control named "Job Title" and a formfield bookmarked "JobTitle" the contents of each are cleared and filled with a new list.

Just pass your document to process to the macro.

HTML Code:
Sub RefillDD(oDoc As Word.Document)
...
 End Sub
tried this code however, i am getting a 'runtime error 424' and highlighting
lngPT = oDoc.ProtectionType.

can anyone assist.
Reply With Quote