none
Extract text from embedded wordpad document RRS feed

  • Question

  • Hello:

    I have a worksheet with an embedded wordpad document.  Is there a way to extract the values contained in that document.  For example, in an empty worksheet, choose "Insert", "Object" and in the list of object, select "Wordpad Document".  Wordpad then comes up.  Enter "Hello World" and then click the X button to close the document.  The words "Hello World" appear in your excel worksheet.

    Now, try, using VBA, to extract the values (i.e. Hello World) from that embedded object.

    Thanks,

    Rich Locus


    Rich Locus, Logicwurks, LLC

    http://www.logicwurks.com

    Sunday, August 21, 2016 4:30 PM

Answers

  • That's going to be difficult since WordPad doesn't have a programming interface.

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by RichLocus Sunday, August 21, 2016 8:02 PM
    Sunday, August 21, 2016 6:49 PM

All replies