• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

List Specifc files

marreco

Member
Is possible list files (PDF) based range?

I want send email (Notes with multiples files) , but i need list files based range

Thank you!!!
 

Attachments

  • Open_PDF_Files_Based_Range.jpg
    Open_PDF_Files_Based_Range.jpg
    199.1 KB · Views: 9
  • Listar_PDF.xlsm
    20 KB · Views: 3
Sure thing. You'll want to have your code loop over the range of cells with file names, get the number/name from the cell, and then use that to tell the code which file to attach. You have to attach files 1 at a time anyway.
 
hi Luke, hum, try imagine way to create loop to show based range, but i can't successful...if have time free and can help me, I'll be grateful
 
How to do a loop?
Code:
Sub example()
Dim fName As String
Dim c As Range

For Each c In Range("A1:A10")
    fName = c.Value
   
    'Do something with the file name
Next c
End Sub
 
Back
Top