Replies

Zeddy – I think this will be my last question.

I want to set a parameter:
scaletofit to no.
would the code just be ” scaletofit=” & chr(32) & “no” & char(32)
Or is there a way to define as no. The above code isnt working

ZEDDY!!!!!! YOU ARE THE MAN!

After weeks of trying to figure this out, with all of your help, it works.

THANK YOU SO MUCH!

Haha – didn’t know where you went, but you disappeared for 3 days from the forum, so i figured you went somewhere!

I guess I may be confused by the bioPDF page. Is “PDFCMD” a space filler for the location of the PDFCMD.exe file?

In other words, Should I put “C:Program FilesbioPDFPDF Writerpdfcmd.exe” where “PDFCMD” is listed?

Welcome back Zeddy!

I am still having trouble here – I am not sure why. I have never worked with shells before.
I sort of just guessed on the format.
I took your advice and removed the “” around zPrintCopies.

Is the standard shell command as follows:
Shell ( *PROGRAM* & *Command* ) (without the * of course).

Okay, with my very limited coding acknowledgement, this is what I came up with.

Shell (zProg & “PDFCMD command=printpdf input=” & Chr(32) & zFile & Chr(32) & ” printer=” & Chr(32) & zPrinter & Chr(32) & ” lastpage=” & Chr(32) & zPrintCopies & Chr(32))

based on bioPDF’s website
http://www.biopdf.com/guide/print_pdf_from_command_line.php#PdfCmd

I am still getting an error. This shell command may be completely off – Any thoughts?

Hey Zeddy! I hope your weekend is going well.

Adobe Acrobat Pro is probably my first choice as I am familiar with it, but if thats not possible, I found this!

I found a program that may work here (bioPDF). Not sure if you have any experience with it.
I found this help file on their website for Command Lines, but I am not sure exactly how to convert the command line into the shell command for my program.
Here is the link. It does allow printing of certain range of pages.
http://www.biopdf.com/guide/print_pdf_from_command_line.php#PdfCmd
From the tutorial, It seems as though my command line should be something like this:

PDFCMD command=printpdf input=zFile printer=zPrinter lastpage=zPrintCopies

In the above example, zFile, zPrintCopies and zPrinter are variables.
I am not sure how to convert this into the shell format that you have been using. Any chance you could help me with this? Hopefully this solves the problem, and I can stop bugging you for help!

Thank you again.Ryan

Thanks Zeddy!
I do have Adobe Acrobat Pro (and not just reader) if that helps. Also, I would be willing to make a smaller purchaser if it would help solve the problem.

Thanks,
Ryan

Hey Zeddy,

Any luck with that code for printing a range of pages in the PDF? I hope its even possible! haha.

Hey Zeddy!

The design of the labels were created in a label generating software. Ideally, we could have done this from the start in, but unfortunately, the files themselves have already been created. There are about 1,000 variations. At some point, these labels are going to require a complete overhaul, but right now, I am trying to patch the hole in the boat! 🙂

Thank you so much Zeddy. I look forward to your response!

Hi Zeddy!

Thank you again for the help. You have been an absolute lifesafer in this process.

This is actually for a label job, so once the initial setup is complete, no new labels will need to be created. I know creating multiple copies of the label in the same PDF is more time up front, but for my application, I think it would be a better option for a few reasons.

The problem is, this is a high speed printer which takes about 30 seconds to print the first label, but can print over 100 labels per minute afterwards. With the loop provided, it is continually printing 1 label, which makes the print time about 20 times longer. Also, our printer has the ability to cut the labels after each job, which allows us to keep the labels organized.

I am not sure if it is even possible to print a range of pages in the PDF, but if it is, would it be possible to modify the code to print a range of pages in the file instead of using the loop?

As always, Thank you Zeddy!

Good Morning All. I know this is an older thread, but I was hoping that someone could help me.
Below is the current code that I am running. Essentially this macro will print external PDF files that are listed in column C.

I am having a little trouble taking this to the next step.
Here is what I am looking to do – hopefully someone can help.

Column C is the file name. Column b is the quantity. I want to print multiple copies of the file depending on what quantity is listed in column b. I figured the best way to do this is to create a PDF with 50 pages of identical files (as the files are very small in size and the print quantity will next extend past 50) and have a function which prints the number of pages in the PDF that correspond to quantity.

For instance, if column b has a quantity of 20, this macro will print pages 1-20 of the given PDF. The problem is, however, while I imagine this code is quite easy for some of you, it is way above my head!

I would appreciate any help available.

Thank you again!
Ryan

Sub printPDFfiles()

zProg = “C:Program FilesAdobeAcrobat DCAcrobatAcrobat.exe”

zLastRow = [c200].End(xlUp).Row
temp = “c9:c” & zLastRow

zPrinter1 = “Afinia L801 Label Printer”
‘~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
For Each cell In Range(temp)
zFile = cell.Value

If zFile Like “*.pdf” Then
Shell (zProg & ” /n /h /t ” & Chr(34) & zFile & Chr(34) & ” ” & zPrinter1)
End If

Next
End Sub