Hello,

I have defined the file path in column A2 [C:\test\stocks.pdf Column A3 C:\test\product.pdf upto 50 rows.]

I am trying this If (Application.Dialogs(xlDialogPrinterSetup).Show) = True Then
If ("sheet1").Range("A2") > 0

codes to achive the goal, they are imcomplete and i need a help to accomplish the task.

This Application.Dialogs(xlDialogPrinterSetup).Show will help me to select the printers available to me, as we have 2 printers and if i don't want a particular row where file path is defined we can cancel it.

Hi

Can you explain if you are trying to print the PDFs from Excel VBA?

Are you trying to select the printer through dialog box

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Hello Shasur,

Thanks for reply, Yes they are existing PDF files in folder, & I want an printer selection dialog box.

Thanks.