Forum Discussion
I need to know how to print files from a folder(pdf and jpg) using the same order in my excel list
With your permission, add more information, in this case this would be helpful, especially for you
... but also for those who would like to help.
Find out about the Excel version, operating system, storage medium (hard drive, OneDrive, Sharepoint, etc.).
Add one or a few photos and explain step by step which exactly is your plan.
...more Infos: Welcome to your Excel discussion space!
Thank you for your understanding and patience
I know I don't know anything (Socrates)
- alambaig725Jan 09, 2022Copper Contributor
NikolinoDE the documents saved on my folder are renamed to match with the "D" column.
Instead of searching and printing one by one, I need to know if there is a way to print these documents on the same order as the D column list.
- Jan 10, 2022The following code will access each of the files in column D in the order in which they appear in that column. You will need to come up with the code to open, print, and close the various types of file.
Dim i As Long
With Sheets(1).Range("D1")
For i = 1 To .CurrentRegion.Rows.Count - 1
If .Offset(i, 0) <> "" Then
'put code here to open the file, print it and close it
End If
Next i
End With - NikolinoDEJan 10, 2022Platinum Contributor
If I may recommend again ...
Inform us about the Excel version, operating system, storage medium (hard drive, OneDrive, Sharepoint, etc.).
Add one or a few photos and explain step by step which exactly is your Issue.
...more Infos: Welcome to your Excel discussion space!
I can very well imagine that it is very annoying when you are working on a project and suddenly everything stops. But please understand that the problem could be very diverse (or very simple).
With Excel you have many possible solutions for your project, but just as many reasons for troubleshooting.
Please also keep in mind that the more time the user who helps want to guess where the problem might be, the more time consuming and annoying it is for you. At the same time, we are users like you, users who are happy to pass on your knowledge (as small as it can sometimes be) willingly and voluntarily.
Drag and drop here or browse files to attachMaximum size: 71 MB • Maximum attachments allowed: 5Thank you for your patience and time.