![]() |
|
|
|
#1
|
|||
|
|||
|
Thanks so much for the reply Paul.
I was able to update the code to replacing ThisDocument.Path to a different path. The pop up box came up, but when I selected the name and clicked okay, I received a Run-time error '5941': The requested member of the collection does not exist. The debugger shows it's part of this sub, and the part bolded and underlined below is what came up as the error: Sub FillCC(strTag As String, strText As String, Optional lngItem As Long = 1) 'Writes data to a targeted CC. With ActiveDocument.SelectContentControlsByTag(strTag). Item(lngItem) .LockContents = False .Range.Text = Replace((Replace(strText, Chr(13) & Chr(10), Chr(11))), "|", Chr(11)) .LockContents = True End With lbl_Exit: Exit Sub End Sub Any ideas why that could cause an error? |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Automatic Update for Excel Spreadsheet | Frenchy305 | Excel | 3 | 07-14-2017 12:17 PM |
| How can I automatically update my spreadsheet with report generated from Access | shilabrow | Excel | 5 | 05-18-2014 03:59 PM |
| Merge large Excel spreadsheet in Word | goharar | Word | 0 | 02-05-2014 05:32 AM |
Creating a list in Word from an Excel spreadsheet
|
gingernut | Mail Merge | 1 | 03-19-2013 02:12 PM |
Inserting excel spreadsheet into word doc
|
educpara58 | Excel | 2 | 07-28-2011 01:22 AM |