Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-09-2017, 10:03 PM
jmattingly85 jmattingly85 is offline Word Doc Update from Excel Spreadsheet Windows 7 64bit Word Doc Update from Excel Spreadsheet Office 2016
Novice
Word Doc Update from Excel Spreadsheet
 
Join Date: Jul 2017
Posts: 6
jmattingly85 is on a distinguished road
Default

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?
Reply With Quote
Reply



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
Word Doc Update from Excel Spreadsheet Creating a list in Word from an Excel spreadsheet gingernut Mail Merge 1 03-19-2013 02:12 PM
Word Doc Update from Excel Spreadsheet Inserting excel spreadsheet into word doc educpara58 Excel 2 07-28-2011 01:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:20 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft