loop trough all folders and subfolders and merge pdf files

[Megatronixs]

Hi all,

I found the below code:

Please Login or Register  to view this content.

on this link:
http://khkonsulting.com/2009/03/adob...-introduction/

I need to adjust it to get the path of the file from excel sheet, starting at row 2 and down. It is possible that it will have only a few or a lot and with different names.

how to create a loop that will set the part 1, part 2 and so on depending on how many files there are in the folder and subfolders.
and, the maybe harder part would be to add also the names of the files as bookmarks in the merged pdf file.

greetings.

[davesexcel]

Please Login or Register  to view this content.

codeBtweenCode.jpg

[Megatronixs]

fixed, no clue what happened.

[davesexcel]

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and click "manage attachments" to open the upload window.


To add a file to a post

[Megatronixs]

Hi,

this is locked at our work, I'm not able to upload things :-(

all it comes down that the one macro gets all the pdf files in a folder and list them on a sheet. Then I want to pass it as this part, but it needs to loop trough them:

Please Login or Register  to view this content.

Greetings.

[Megatronixs]

Hi all,

I found some other code that works fine too, but I get stuck on the array part :-(

This is the code that is almost working now:

Please Login or Register  to view this content.

The "myArray" is the part that actually does not build up the array and then the merge pdf files is empty and stops.

Any way to find the error above?

Greetings.

[Megatronixs]

ok, so the problem here is that the array has an extra blank value at the end. this causes the pdf merging to fail.
how to get rid of this extra blank value there?

Greetings.