Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #14  
Old 12-20-2013, 02:10 PM
macropod's Avatar
macropod macropod is offline programmatically inserting hidden text into a Word 2010 table Windows 7 32bit programmatically inserting hidden text into a Word 2010 table Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,375
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

The code I posted works fine for me with your document & tables. As for the second problem, try:
Code:
Sub update_cell_data()
    Dim Rng As Range, aTable As Table, TblCell As Cell, cellvalue As String, CellID As String
     cellvalue = "test data"  ' new value to insert into the cell below
    CellID = "Cell_ID[2, 2]"
    ' temporarily turn on hidden text
    ActiveDocument.ActiveWindow.View.ShowHiddenText = True
    For Each aTable In ActiveDocument.Tables
        For Each TblCell In aTable.Range.Cells
            With TblCell
                Set Rng = .Range
                With Rng
                    If InStr(.Text, CellID) > 0 Then
                        .End = .Start + InStr(.Text, CellID) - 1
                        .Text = cellvalue
                        .Font.Hidden = False
                        Exit For
                    End If
                End With
            End With
        Next TblCell
    Next aTable
    ' turn off hidden text
    ActiveDocument.ActiveWindow.View.ShowHiddenText = False
End Sub
I do wonder, though, why you want to put so much hidden text in the cells. If all you need to do is to populate a given cell with some content, you can do so explicitly. For example:
Code:
Sub update_cell_data()
    Dim aTable As Table, cellvalue As String
    cellvalue = "test data"  ' new value to insert into the cell below
    For Each aTable In ActiveDocument.Tables
        aTable.Cell(2, 2).Range.Text = cellvalue
    Next aTable
End Sub
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 

Tags
vba, vba word, word table



Similar Threads
Thread Thread Starter Forum Replies Last Post
programmatically inserting hidden text into a Word 2010 table getting rid of hidden text in MS word allenglishboy Word 1 11-06-2012 05:48 PM
programmatically inserting hidden text into a Word 2010 table Hidden text in table Angel9520 Word Tables 1 05-02-2012 01:00 AM
programmatically inserting hidden text into a Word 2010 table Hidden style applied over already-hidden text. christie Word 1 08-17-2011 09:10 AM
inserting a string of data into an MS Word table??? matto Word VBA 0 07-16-2010 09:35 AM
Programmatically get File Path for currently opened WORD document franferns Word 1 11-26-2009 12:36 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:29 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