Combine word documents in hyperlink list

I am new in the world of VBA. I would look for help for my problem.

I have list of file in range B3:40. In each cells, hyperlink to specific word document (.docx) file in the communal server.
Now, I would like to combine all documents in the hyperlink list in that range become one new document that contain all documents in the list using VBA excel.

Below is my code. I just can open it, but don't know how to combine it.

Thank you in advance for any help.

Please Login or Register  to view this content.

Originally Posted by vba_php

ok, sorry to offer something of no value. so, if you want to combine the CONTENT in every word document into one full master document, the only thing I can really think of is just to use the COPY function in code to do it. but you know, you really haven't given people any clue as to what kind of content is in these documents. and furthermore, how you want the output to look. the one thing that is true for you at this point, and always will be, is that word has what is called an object model associated with it, just like every program in the world does. Objects are the basis of coding in any language, manufactured by every corporation in the world. so, how similar are all of these documents? and if they are similar, I assume you are simply wanting to take content of doc ''1'', paste it into the top of the master doc, then take content from doc ''2'', paste it into the master doc below content for doc ''1'', and on and on, etc....??

Hi vba_php

I don't know if this will help you

I have a list of word document in excel in range B3:B40. I would like to copy the document in the list and paste to a new document without changing the page format.

I tried this code

Please Login or Register  to view this content.

But it give me "run time error 13".

Originally Posted by mattmar

Hi vba_php

I don't know if this will help you

I just want to clarify. I am not needing help. you are. (just kidding, sort of). I appreciate your words though. We are all here to help you, and obviously you have to help us help you.

so, to the point....I ran the code you posted, which was this:

Please Login or Register  to view this content.

and, based on what I saw by replicating exactly what I think you are doing on your end, the code will obviously break on this line:

Please Login or Register  to view this content.

because you are attempting to open a single word document object by referring to all of them at once. yeah, that won't work. so, here is something to get you started, which loops through all of the documents in a replicated excel range on my end, which consists of 6 cells only, one by one, and opening the word doc and then closing it, one by one. I have stripped all other code out for this test. that way, you can do that work on your own since you already had that code written anyway. let us know when you get stuck again:

Please Login or Register  to view this content.

Originally Posted by vba_php

I just want to clarify. I am not needing help. you are. (just kidding, sort of). I appreciate your words though. We are all here to help you, and obviously you have to help us help you.

so, to the point....I ran the code you posted, which was this:

Please Login or Register  to view this content.

and, based on what I saw by replicating exactly what I think you are doing on your end, the code will obviously break on this line:

Please Login or Register  to view this content.

because you are attempting to open a single word document object by referring to all of them at once. yeah, that won't work. so, here is something to get you started, which loops through all of the documents in a replicated excel range on my end, which consists of 6 cells only, one by one, and opening the word doc and then closing it, one by one. I have stripped all other code out for this test. that way, you can do that work on your own since you already had that code written anyway. let us know when you get stuck again:

Please Login or Register  to view this content.

Hi,

Really appreciate for your time and help.
I already tried it, it give me "run time error 424".

And for other option (In case I am not able to do this one, because I think I run out of time), instead of copy all the documents to the new document, I just simply copy the document in the list from the source folder to the destination folder. I already tried this code,

Please Login or Register  to view this content.

But I got two problem:
1. It copy all the documents in the folder not just specific file in the list
2. It wont work when I change the worksheet. (In the workbook there are multiple worksheet, range don't work)

Did you change Sheet1 to Sheet6 to match your current working code?

A couple of minor things:

1. You should presumably be using objtempword, not objword, in that line.
2. You don't need to append another backslash to the Folderpath variable as it already ends in one.
(and 3, obviously that code doesn't actually do anything useful at this stage)

Not necessarily - it was actually ignored in my tests, and it shouldn't produce that error anyway (it should be some sort of 'file not found' error).

Originally Posted by mattmar

I already did what you suggested, but it just give me blank word document

Quite - note my point 3. All the code currently does is open and close a load of documents.