Request VBA Macro - Using DOS Command - Reposting

Hi,

I want to thank you for introducing me to the PDF Tool Kit. It appears to be very powerful and very fast.

Try the attached file which does the following:
a. Deletes output file 'Reorder.pdf' if it exists.
b. Sorts the data by Image Type (Column D)
c. Creates a .bat file to run 'pdftk.exe'.
d. Runs the .bat file to create an output .pdf file.
e. Optionally deleted\s file 'Scratch00.bat'.
f. Opens the output .pdf file (Reorder.pdf)

NOTES:
1. It is assumed that all files are in the folder that contains the attached Excel file.
2. File 'Pdftk.exe' must be in an accessible path. NOTE: I had problems running it from a path that contained embedded spaces.
If 'Pdftk.exe' is NOT ACCESSIBLE, it is suggested to put a copy in the folder that contains this file.
3. The program times out if the output file 'Reorder.pdf' has not been created in 5 seconds.
4. The program uses scratch files 'Scratch00.bat' and 'Scratch01.txt'

If it appears that 'pdftk.exe' does not run, you may be able to modify the constant 'sPathAndPdftkDotExeNAME' at the top of Module 'ModAutomatePdftk' to become something like: 'c:\pdftk\pdftk.exe'.

Lewis

Hi Lewis,

Really wondering this reply

I have one update on this program.

I am processing more than 25 files per day and we need to copy the exe file in each files folder to reorder.

So kindly change the exe file path is constant i.e. it will update Excel cell itself. (K4, H5)

Please help to do this request.

Thanks in advance.

Hi,

Try the attached file. I think it does what you want. It allows you to select:
a. The location of 'pdftk.exe' (only has to be done once).
b. The location (folder) that contains the data files (only has to be done when the location changes).
c. It assumes that file 'Imgtype.pdf' is always the name of the input pdf file.

Please let me know if you need any additional changes.

Lewis

Hi All,

Currently using Office 2019, and got Compile Error, and request experts opinion for above scripts.


Attachment 866809

I appreciate if anyone help in this matter.

Thank you
G