+ Reply to Thread
Results 1 to 2 of 2

VBA: Open an Embedded Excel worksheet (from Word) to NEW Excel file?

  1. #1
    Registered User
    Join Date
    09-25-2020
    Location
    USA
    MS-Off Ver
    2016
    Posts
    1

    VBA: Open an Embedded Excel worksheet (from Word) to NEW Excel file?

    I have a Word document that is full of embedded Excel sheets. These embedded worksheets are not searchable using the Ctrl+F function in Word. I would like to be able to search these embedded sheets without having to open each one individually, as there are A LOT.

    So, using VBA, I am looking to find/open each embedded Excel worksheet and save each into a new Excel file. (Each embedded worksheet would now be its own .xls file, say on the Desktop). That way, I can then write a Excel VBA subroutine to search all of the new workbooks for a specific string, for example.

    I have explored some ways to do this online, but none are promising. Is this possible? Is there a better way to do this? I am new to VBA.
    Last edited by mll5426; 09-25-2020 at 02:21 PM.

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: VBA: Open an Embedded Excel worksheet (from Word) to NEW Excel file?

    yes there is probably a better way, and, IMO, that would be to have a completely different set up. if you don't mind me asking, why do you have a ton of embeddings in a word document anyway? how did things get that way? tables and grids belong in excel, not in word.

    and the answer to your question, about whether or not you can do this with code, the answer is more than likely yes, even without doing research on it, primarily because every office program has an object model, and literally anything you see on the screen in any office program can be referenced in code somehow.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. From within Word: Open userform in embedded excel workbook
    By ruud1957 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-18-2020, 03:58 AM
  2. Open embedded excel file (in a word document) using VBA from excel workbook
    By ChrisHook in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-31-2016, 01:31 PM
  3. Word embedded Excel file to open automatically
    By Dunctonsteel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-01-2013, 03:16 PM
  4. open and manipulate embedded word documents from excel?
    By mcledavid in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-21-2009, 04:24 PM
  5. exce; macro to open, save embedded pdf, word, excel, ppt files to a folder
    By mcledavid in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-16-2009, 05:17 PM
  6. Replies: 0
    Last Post: 09-16-2009, 05:11 PM
  7. [SOLVED] Embedded Excel file in Word
    By QOAT in forum Excel General
    Replies: 1
    Last Post: 03-31-2006, 01:10 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1