Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 10-25-2012, 10:13 AM
mpdsal mpdsal is offline Update Word table based on another table input Windows XP Update Word table based on another table input Office 2007
Novice
Update Word table based on another table input
 
Join Date: Nov 2011
Posts: 19
mpdsal is on a distinguished road
Default

I figured it out for changing background. It seems to work. Any modifications suggested will be taken into consideration. Appreciate everyone who contributed.

Sub CopyBackground()
Dim myCells As Range
Dim celTable As Cell
Dim I As Long
Dim J As Long

I = ActiveDocument.Tables(7).Rows.Count

J = ActiveDocument.Tables(4).Rows.Count

For N = 1 To I
Set celTable = ActiveDocument.Tables(7).Cell(N, 3)

ActiveDocument.Tables(4).Cell(N, 3).Shading.BackgroundPatternColor = celTable.Shading.BackgroundPatternColor
Next N


End Sub
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking excel table to powerpoint for easy update atwood121 PowerPoint 0 05-11-2012 07:09 AM
Update Word table based on another table input How do I dynamically update data in a Word Document from a database table RSchmidt Word 1 07-14-2011 04:27 PM
Table update in running presentation rumdrum PowerPoint 0 02-10-2011 01:28 PM
Update Word table based on another table input SOS - cannot update table of content properly Lee Word 5 02-04-2011 12:59 PM
Easy Update "Table of Contents" feature in Microsoft Word 2007 VS. Word 2010 Xarzu Word 0 09-22-2010 06:54 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:29 AM.


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