#1
|
|||
|
|||
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? |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
Is Activation done using VBA? So is it possible to Activate all the embedded Excel sheets and then perform a CTRL +F?
|
#4
|
||||
|
||||
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] |
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 |
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 |