nesher13
asked on
Print pdf files from folder, matching the numbers in the Excel column
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"
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"
ASKER
cell in the Excel spreadsheet is:
123456
the file name just
123456.pdf
123456
the file name just
123456.pdf
A few more questions:
(1) Is the Excel spreadsheet in the same folder as the PDF files?
(2) Do you already have a program installed that can print a PDF file via the command line? I recommend it to have a "quiet/no-UI" option so that the program doesn't appear for each file that is printed.
(3) Do you want to print to the default printer or be able to specify (by name) which printer to use?
(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?
Regards, Joe
(1) Is the Excel spreadsheet in the same folder as the PDF files?
(2) Do you already have a program installed that can print a PDF file via the command line? I recommend it to have a "quiet/no-UI" option so that the program doesn't appear for each file that is printed.
(3) Do you want to print to the default printer or be able to specify (by name) which printer to use?
(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?
Regards, Joe
ASKER
Joe Winograd
(1) no
(2) I'm going to print pdf using command: Start-Process -FilePath $filepath :\Invoice.pdf"
(3) I want to print to the default printer
(4) The script have to be written in PowerShell
Regards, nesher13
(1) no
(2) I'm going to print pdf using command: Start-Process -FilePath $filepath :\Invoice.pdf"
(3) I want to print to the default printer
(4) The script have to be written in PowerShell
Regards, nesher13
Sorry — if it must be in PowerShell, I can't help you. Regards, Joe
ASKER
the question is no longer relevant
Why?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I've requested that this question be closed as follows:
Accepted answer: 0 points for nesher13's comment #a40466173
for the following reason:
the script is combination This script is a combination of data foundув from the Internet
Accepted answer: 0 points for nesher13's comment #a40466173
for the following reason:
the script is combination This script is a combination of data foundув from the Internet
I know very little about PowerShell, but my programming background in other languages makes me wonder where that code displays the message "In the folder does not corresponding invoice number" for those numbers that do not have corresponding PDF files. I'd like to understand this. Thanks, Joe
ASKER
I want to close the question
That's fine. I did not object to your closing the question. I simply made another post in the hopes of understanding how that script solves the question you asked.
123456
is the file name just
123456.pdf
or could it be
Invoice 123456.pdf
or inv_123456_20141109.pdf
or whatever? Regards, Joe