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