+ Reply to Thread
Results 1 to 3 of 3

Copy an embedded word document and paste into a folder

  1. #1
    Registered User
    Join Date
    02-13-2017
    Location
    Durham
    MS-Off Ver
    2010
    Posts
    88

    Copy an embedded word document and paste into a folder

    Hi Guys,

    As my title states - Is it possible to copy 'multiple' embedded word documents from a workbook and then place them into a designated folder?

    Having done a little research I see people with varying success of copying OLEobjects however it all seems to evolve around having the actual name of the document. In my case the names will always be different so it would have to be a general sweep on either the worksheet or the Colum they're held in

    Thanks

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    6,065

    Re: Copy an embedded word document and paste into a folder

    Try something like this. Change the save path to suit.

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in your menu for the forum editor will apply the CODE tags around your selected text.

  3. #3
    Valued Forum Contributor
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,426

    Re: Copy an embedded word document and paste into a folder

    Please Login or Register  to view this content.
    Cheers!
    Tsjallie




    --------
    If you appreciate my help click * at the bottom of my post. Thank you!

    If you think design is an expensive waste of time, try doing without ...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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