![]() I have attached a sample file containing this code. Meanwhile, you can close the Adobe session manually. Perhaps someone here can tell us that bit. Note that after printing all the files, it leaves the Adobe Reader open. Shell (zProg & " /n /h /t " & zFile) 'execute command to print the pdf document If zFile Like "*.pdf" Then 'check it is a pdf file type ZFile = cell.Value 'fetch filename from cell End(xlUp).Row 'find last row in column e.g. ZProg = "C:Program Files (x86)AdobeReader 11.0ReaderAcroRd32.exe" 'zProg = "C:Program Files (x86)AdobeReader 10.0ReaderAcroRd32.exe" 'CHECK YOUR ADOBE READER VERSION, AND USE CORRECT PATH. 'If you are using Acrobat, substitute Acrobat.exe in place of AcroRd32.exe 'NOTE:Example below uses Adobe Reader, but apply to Acrobat as well. 'ChDrive "E" '<< if your files are on a different drive!
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |