Thread: [Solved] Make Embedded Excel Sheets SEARCHABLE in Word
View Single Post
 
Old 11-11-2020, 04:20 PM
macropod's Avatar
macropod macropod is offline Windows 10 Office 2010
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
You could use code like that found in:
https://www.msofficeforums.com/87465-post4.html
vba - Referring Excel objects which embedded in a MS-Word Document? - Stack Overflow
leaving an embedded object (excel sheet) and returning back to word
to loop through all the embedded workbooks, then use Excel's Find function on the activated workbook.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote