Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-29-2015, 10:01 PM
ndandge ndandge is offline Find Tables & Figures Missing Captions Windows 7 64bit Find Tables & Figures Missing Captions Office 2007
Novice
Find Tables & Figures Missing Captions
 
Join Date: Nov 2015
Posts: 8
ndandge is on a distinguished road
Post Find Tables & Figures Missing Captions

Hi,



Sorry I have one more request.

as I told earlier, I receive thousands of pages of Tables and Figures.

Each page has Table title or Figure Title on top. However on some pages, this table title or Figure title is missing. Can some one please help me and create macro which will list the pages where this title is missing.

These Titles have 'Arial' font and '11' Font size. Table or Figure content has either '10' or '9' font size (If this helps to differentiate title from rest of page).

Thanks in advance for your help!
Reply With Quote
  #2  
Old 11-29-2015, 10:13 PM
macropod's Avatar
macropod macropod is offline Find Tables & Figures Missing Captions Windows 7 64bit Find Tables & Figures Missing Captions Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

Have you used a Style (e.g. Word's Caption Style) for the Table/Figure titles? Do any of your Tables/Figures span more than one page? If so, what do you expect to happen with the second & subsequent pages the same Table/Figure appears on? Are the Figures just text, or are they something else?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 11-29-2015, 11:34 PM
ndandge ndandge is offline Find Tables & Figures Missing Captions Windows 7 64bit Find Tables & Figures Missing Captions Office 2007
Novice
Find Tables & Figures Missing Captions
 
Join Date: Nov 2015
Posts: 8
ndandge is on a distinguished road
Default

Thanks for the reply.

Yes. First page of Table or Figure title has caption style and if Table\Figure spans more than 1 page, it has normal style on second and subsequent pages.

Only thing I think separating the Title from rest of page is font.

'Arial' font and '11' Font size.

Figures are embedded image files. However Figure Titles are texts.
Reply With Quote
  #4  
Old 11-30-2015, 03:18 AM
macropod's Avatar
macropod macropod is offline Find Tables & Figures Missing Captions Windows 7 64bit Find Tables & Figures Missing Captions Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

So how does one tell that the Table or Figure spans more than one page and that subsequent pages are NOT different Tables or Figures?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 11-30-2015, 04:05 AM
ndandge ndandge is offline Find Tables & Figures Missing Captions Windows 7 64bit Find Tables & Figures Missing Captions Office 2007
Novice
Find Tables & Figures Missing Captions
 
Join Date: Nov 2015
Posts: 8
ndandge is on a distinguished road
Default

All the Tables and Figures have Unique Table\Figure number in Title. So if Table spans more than 1 page, all the pages will have table title containing Unique Table number. Also all the tables will have page numbers like 'page 1 of 10'.

e.g. If Table 1.1 is of 3 pages, all 3 pages will have 'Table 1.1' in Table title.
Reply With Quote
  #6  
Old 11-30-2015, 04:43 AM
macropod's Avatar
macropod macropod is offline Find Tables & Figures Missing Captions Windows 7 64bit Find Tables & Figures Missing Captions Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

Previously (https://www.msofficeforums.com/word-...html#post91935), you said "Tables and Figures are separated by Section Breaks". So, if each Table or Figure is preceded by a Section Break, all one should need to do is look for Section Breaks that aren't followed by a Titles in 11pt Arial?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 12-01-2015, 05:02 AM
ndandge ndandge is offline Find Tables & Figures Missing Captions Windows 7 64bit Find Tables & Figures Missing Captions Office 2007
Novice
Find Tables & Figures Missing Captions
 
Join Date: Nov 2015
Posts: 8
ndandge is on a distinguished road
Default

Yes. you are right. All the tables and figures are separated by Section Break.
However if Tables and Figures span more than 1 page, then each internal page is will have page break at the end.

e.g. If Table X is of 3 page, page 1 and 2 will have page break at the end. As table is going to end on page 3 and new table will start on page 4, Page 3 will have section break at end.

I hope it clarifies. Sorry for bad English.
Reply With Quote
  #8  
Old 12-01-2015, 09:29 PM
macropod's Avatar
macropod macropod is offline Find Tables & Figures Missing Captions Windows 7 64bit Find Tables & Figures Missing Captions Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

Try:
Code:
Sub Demo()
Dim i As Long, j As Long, strOut As String
With ActiveDocument
  For i = 1 To .Sections.Count
    With .Sections(i).Range.Characters.First
      If (.Font.Name = "Arial") And (.Font.Size = 11) Then
      Else
        strOut = strOut & vbCr & "Section " & i & " on page " & .Information(wdActiveEndAdjustedPageNumber)
      End If
    End With
  Next
End With
If strOut = "" Then
  strOut = "No Missing Captions"
Else
  strOut = "Captions Missing From:" & strOut
End If
MsgBox strOut
End Sub
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 12-03-2015, 05:05 AM
ndandge ndandge is offline Find Tables & Figures Missing Captions Windows 7 64bit Find Tables & Figures Missing Captions Office 2007
Novice
Find Tables & Figures Missing Captions
 
Join Date: Nov 2015
Posts: 8
ndandge is on a distinguished road
Default Sorry, It didn't work:(

Thanks for the effort! However provided code didn't work.

I tried it on small File. It had 10 page table and on page 4 Title was missing, but it said No missing Caption.
Reply With Quote
  #10  
Old 12-03-2015, 01:36 PM
macropod's Avatar
macropod macropod is offline Find Tables & Figures Missing Captions Windows 7 64bit Find Tables & Figures Missing Captions Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

It works for me. Your result indicates that, regardless of whether you had a title, whatever was in the first paragraph on the page in question was in 11pt Arial.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Modifying captions in Table of Figures CoffeeNut Word 5 03-30-2013 01:40 PM
Captions not appearing underneath figures bradyj Word 1 01-18-2013 01:17 PM
Word 2011 - Figures/Captions help kenno69 Word 0 03-31-2012 06:23 AM
Find Tables & Figures Missing Captions creating tables for row of figures and captions gib65 Word 2 08-12-2011 01:25 PM
Find Tables & Figures Missing Captions Captions (tables and figures) mcjohn Word 1 02-11-2010 10:36 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:16 AM.


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