So I have been playing around with your code a bit, and this is what I am seeing. When I use the F8 command it will go through the entire code, but when it gets to:
it skips the rest. If I switch out the "=HYPERLINK" to "=IF" and change the 10 to a 3, it will go through the rest of the code, but will still not attach any of the files.
I am assuming that the next problem is in the line:
But I am unable to figure out what each part of the code means. I think the Chr$(10) means the number of characters in the row, but even increasing that, doesn't help. The rest I am not sure of.
Any thoughts, or can you explain to me what that line is saying?
Bookmarks