Print PDF files from folder.

[Tofik]

Hi guys, I need a VBA formula which can help me with PDF files PRINTING.

How I thing it should be ? :
1) Excel with button ( Print ) Which print all cells with numbered files.
2) Folder include reports names : 12763-12764_AZF-CS-4004 and in excel I write only AZF-CS-4004. Is it possible to Print in this way or I should write all the file name like 12763-12764_AZF-CS-4004 ?
3) Print sequence to avoid manual sorting printed papers.

 

[John_w]

The error occurs because Set Sh = CreateObject("Shell.Application") failed and therefore the Sh object is undefined (Nothing), probably because your account doesn't have the required permissions to access the Windows shell.

 

[spasmex97]

The error occurs because Set Sh = CreateObject("Shell.Application") failed and therefore the Sh object is undefined (Nothing), probably because your account doesn't have the required permissions to access the Windows shell.

how can i fix that?

 

[John_w]

First, step through the code with F8 to confirm my theory. If I'm correct, you would need to set the permissions. Also check that what I said in post #5 is true for you:

This macro should work, as long as Print is shown in the context menu when you right-click on a PDF file in File Explorer, because it uses the Shell32 object.

 

[spasmex97]

First, step through the code with F8 to confirm my theory. If I'm correct, you would need to set the permissions. Also check that what I said in post #5 is true for you:

i tried with F8 too, so i found the blockage, i also can't try that third step you gave until i solve the error

 

[John_w]

Checking the 'third step' is simply you manually interacting with the File Explorer UI and nothing to do with the VBA error or Excel.

 

[spasmex97]

unfortunately i couldn't find anything about spooling on my printer's properties

 

[Bond00]

If you have Win11 it might not show you the print button option when you right click on the file. To fix that you can do this:
Command Prompt Shortcut to Create the Required Registry to Enable ‘Show more options’ by Default
open the Command Prompt -> select ‘Run as Administrator’
So click Start button and type cmd then when it shows up right click it and select ‘Run as Administrator’ then paste this line into the black screen

reg add HKCU\Software\Classes\CLSID\{86ca1aa0-34aa-4e8b-a509-50c905bae2a2}\InprocServer32 /ve /d "" /f

If you wanna undo that and go back to the default Win11 right-click options, you can use this:

reg.exe delete “HKCU\Software\Classes\CLSID\{86ca1aa0-34aa-4e8b-a509-50c905bae2a2}” /f