+ Reply to Thread
Results 1 to 6 of 6

Copy an embedded word document and paste into a folder

  1. #1
    Forum Contributor
    Join Date
    02-13-2017
    Location
    Durham
    MS-Off Ver
    2013
    Posts
    126

    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,727

    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
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,789

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

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




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

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

  4. #4
    Forum Contributor
    Join Date
    02-13-2017
    Location
    Durham
    MS-Off Ver
    2013
    Posts
    126

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

    Hi Guys,

    Apologies for the late reply!

    Both your codes seem to work in regards to searching the sheet/column for the word doc however they don't seem to save in the designated path. Any ideas?

    Thanks

  5. #5
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,789

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

    Retrieving the full name and path of the documents is only possible when "link to file" has been selecting when they where inserted.
    Are the files in your workbook linked or just embedded?

  6. #6
    Forum Contributor
    Join Date
    02-13-2017
    Location
    Durham
    MS-Off Ver
    2013
    Posts
    126

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

    Hi Tsjallie,

    They were imbedded however I managed to get it resolved thank you
    The code grabs them and pulls them through to a folder, naming them object 1, object 2 etc. It's a shame they don't get named what they are in the actual workbook but that's fine.

+ 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