<div>
Is the entire file name just the invoice number or are there other characters in the file name? For example, if a cell in the Excel spreadsheet is:<br />
<br />
123456<br />
<br />
is the file name just<br />
<br />
123456.pdf<br />
<br />
or could it be<br />
<br />
Invoice 123456.pdf<br />
<br />
or inv_123456_20141109.pdf<br />
<br />
or whatever? Regards, Joe
</div>


<div>
cell in the Excel spreadsheet is:<br />
<br />
123456<br />
<br />
the file name just<br />
<br />
123456.pdf
</div>


<div>
A few more questions:<br />
<br />
(1) Is the Excel spreadsheet in the same folder as the PDF files?<br />
<br />
(2) Do you already have a program installed that can print a PDF file via the command line? I recommend it to have a &quot;quiet/no-UI&quot; option so that the program doesn't appear for each file that is printed.<br />
<br />
(3) Do you want to print to the default printer or be able to specify (by name) which printer to use?<br />
<br />
(4) I see that your Tags and Topics for this question include PowerShell. Does the script have to be written in PowerShell or can it be in another scripting language?<br />
<br />
Regards, Joe
</div>


<div>
Joe Winograd<br />
<br />
(1) no<br />
<br />
(2) &nbsp;I'm going to print pdf using command: Start-Process -FilePath $filepath :\Invoice.pdf&quot;<br />
<br />
<br />
(3) &nbsp;I want to print to the default printer <br />
<br />
(4) &nbsp;The script have to be written in PowerShell <br />
<br />
Regards, nesher13
</div>


<div>
Sorry — if it must be in PowerShell, I can't help you. Regards, Joe
</div>


<div>
the question is no longer relevant
</div>


<div>
I've requested that this question be closed as follows:<br />
<br />
Accepted answer: 0 points for nesher13's comment <a href="https://www.experts-exchange.com/questions/28553806/Print-pdf-files-from-folder-matching-the-numbers-in-the-Excel-column.html?anchorAnswerId=40466173#a40466173" rel="ugc">#a40466173</a><br />
<br />
for the following reason:<br />
<br />
the script is combination This script is a combination of data foundув from the Internet
</div>


<div>
I know very little about PowerShell, but my programming background in other languages makes me wonder where that code displays the message &quot;In the folder does not corresponding invoice number&quot; for those numbers that do not have corresponding PDF files. I'd like to understand this. Thanks, Joe
</div>


<div>
I want to close the question
</div>


<div>
That's fine. I did <b>not</b> object to your closing the question. I simply made another post in the hopes of understanding how that script solves the question you asked.
</div>


<div>
<div class="content wysiwyg-content">
Hi folks,<br />
<br />
I need to write the script performs the following tasks:<br />
<br />
there is a column of numbers in Excel . Column's length is not known beforehand. On the other hand there is the folder that contains the files of invoices in PDF format. it is necessary to print all existing files matching the numbers in the column and for those numbers that do not have corresponding the &nbsp;pdf files, to display a message: &quot;In the folder does not corresponding invoice number&quot;
</div>
</div>


Hi folks,

I need to write the script performs the following tasks:

there is a column of numbers in Excel . Column's length is not known beforehand. On the other hand there is the folder that contains the files of invoices in PDF format. it is necessary to print all existing files matching the numbers in the column and for those numbers that do not have corresponding the  pdf files, to display a message: "In the folder does not corresponding invoice number"

Print pdf files from folder, matching the numbers in the Excel column

A scripting language is a programming language that supports scripts, programs written for a special run-time environment that automate the execution of tasks that could alternatively be executed one-by-one by a human operator. Scripting languages are often interpreted (rather than compiled). Primitives are usually the elementary tasks or API calls, and the language allows them to be combined into more complex programs. Environments that can be automated through scripting include software applications, web pages within a web browser, the shells of operating systems (OS), embedded systems, as well as numerous games. A scripting language can be viewed as a domain-specific language for a particular environment; in the case of scripting an application, this is also known as an extension language.

Scripting Languages

Windows 7 is an operating system from Microsoft. Features include multi-touch support, a redesigned Windows Shell with a new taskbar, referred to as the Superbar, a home networking system called HomeGroup, and performance improvements.

Windows 7

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.