amb2301
New member
- Joined
- May 18, 2020
- Messages
- 15
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- excel 2013
Hi Friends,
My Current Task:
Actually i have multiple folders (Folder1,Folder2,.....Folderx) each folder contains 5 standard sub-folders (Wordx, PDF1, PDF2, output, other)
now i have a task like... to open (Folder1)main folder & merge PDF files from different Subfolders (Wordx, PDF1, PDF2) and finally merged PDF has to be kept in subfolder (Output).
to do this task i found a script from
http://www.vbaexpress.com/forum/showthread.php?47310&p=353568&viewfull=1#post353568
this script working fine for merging PDFs inside the sub folders
But the problem is.. everytime i need to mention till filename in excel range
like D:\RXT teams\documents\Folder1\Wordx\Level1.pdf.
is it possible to just give till D:\RXT teams\documents\Folder1\Wordx\
& consider the PDFs inside that folder for merging?
Kindly help me to complete my task.
Thanks in Advance.
My Current Task:
Actually i have multiple folders (Folder1,Folder2,.....Folderx) each folder contains 5 standard sub-folders (Wordx, PDF1, PDF2, output, other)
now i have a task like... to open (Folder1)main folder & merge PDF files from different Subfolders (Wordx, PDF1, PDF2) and finally merged PDF has to be kept in subfolder (Output).
to do this task i found a script from
http://www.vbaexpress.com/forum/showthread.php?47310&p=353568&viewfull=1#post353568
this script working fine for merging PDFs inside the sub folders
But the problem is.. everytime i need to mention till filename in excel range
like D:\RXT teams\documents\Folder1\Wordx\Level1.pdf.
is it possible to just give till D:\RXT teams\documents\Folder1\Wordx\
& consider the PDFs inside that folder for merging?
Kindly help me to complete my task.
Thanks in Advance.
Last edited: