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
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 the forum editor will apply CODE tags around your selected text.
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 ...
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
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?
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks