I cannot control PDFtk through VBA code

I am using PDFtk Server but not for passwords, so I haven't done this exact thing. But your code looks correct. How about the data? If you have spaces in your paths this won't work. You need to quote the strings. It's easy to try this change:

ShellCmd = PDFtkPath & " """ & InputFilePath & """ output """ & OutputFilePath & """ user_pw " & Password

Can you either

Attach the file (see yellow banner at the top of the page)

or

show all your code

see here the VBA code tested; many thanks

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however we recommend that you include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Guideline #2 about code tags and adjust accordingly.

I did it for you because you are a new member.

You are calling the Windows version of the app. You need to use the Server for line commands. Change your line of code to this:

Please Login or Register  to view this content.

You still need to use my version of the shell call with the quotes if you have any spaces in the file path. I would recommend you do it anyway.

Please Login or Register  to view this content.

Glad to hear it was solved. I gave you the PDFtk path as it is installed on my machine. Maybe yours is different.

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking addreputationiconsmall.jpg below their name.