Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-11-2020, 03:52 PM
mll5426 mll5426 is offline Make Embedded Excel Sheets SEARCHABLE in Word Windows 10 Make Embedded Excel Sheets SEARCHABLE in Word Office 2016
Novice
Make Embedded Excel Sheets SEARCHABLE in Word
 
Join Date: Nov 2020
Posts: 2
mll5426 is on a distinguished road
Default Make Embedded Excel Sheets SEARCHABLE in Word

I have a few Word docs that’s have maybe a hundred embedded Excel sheets in them. As you know, if you CTRL + F in the documents, the search function does not search for keywords within the embedded objects. Which is a real pain, and forces me to waste time scrolling through pages until I find a keyword.

Is there any way to make this search feature possible?
Reply With Quote
  #2  
Old 11-11-2020, 03:57 PM
macropod's Avatar
macropod macropod is offline Make Embedded Excel Sheets SEARCHABLE in Word Windows 10 Make Embedded Excel Sheets SEARCHABLE in Word Office 2010
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

To search an embedded object of any kind, you have to activate that object, then use the search functions of the object's parent application.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 11-11-2020, 04:02 PM
mll5426 mll5426 is offline Make Embedded Excel Sheets SEARCHABLE in Word Windows 10 Make Embedded Excel Sheets SEARCHABLE in Word Office 2016
Novice
Make Embedded Excel Sheets SEARCHABLE in Word
 
Join Date: Nov 2020
Posts: 2
mll5426 is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
To search an embedded object of any kind, you have to activate that object, then use the search functions of the object's parent application.
Is Activation done using VBA? So is it possible to Activate all the embedded Excel sheets and then perform a CTRL +F?
Reply With Quote
  #4  
Old 11-11-2020, 04:20 PM
macropod's Avatar
macropod macropod is offline Make Embedded Excel Sheets SEARCHABLE in Word Windows 10 Make Embedded Excel Sheets SEARCHABLE in Word Office 2010
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 2007 suddenly not showing embedded Excel sheets Magnus_N Word 5 05-13-2015 04:44 AM
Embedded Excel Forms in Word JamieGale Word 5 08-07-2014 12:15 AM
Using Embedded Links between Excel and Word Blaskowski Office 1 01-24-2014 04:37 PM
Make Embedded Excel Sheets SEARCHABLE in Word Can a word file be searchable and uneditable? Afabiusc Word 3 04-28-2012 08:49 AM
Searchable list in excel? leahca Excel 7 11-24-2011 04:44 AM

Other Forums: Access Forums

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