May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.
Sub MergePDF() Dim sDir As String Dim sFileA As String Dim sFileB As String Dim sOutput As String sDir = Range("B2") sFileA = Range("B3") sFileB = Range("B4") sOutput = Range("B5") Open sDir & "\" & "temp.bat" For Output As #1 Print #1, "cd " & sDir Print #1, "pdftk " & sFileA & " " & sFileB & " cat output " & sOutput Close #1 Sleep 5000 Shell sDir & "\" & "temp.bat" End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Need Assistance Implementing ShockWaveFlash Object in Excel VBA||3||25|
|need help to look for||16||42|
|can you help get 64bit version of these 3 APIs?||4||34|
|Excel - merge column values||3||26|
Join the community of 500,000 technology professionals and ask your questions.