How do you want to run this macro? by clicking on a button, on a cell with the name in column A.
Also the path is always like this? C:\DR + column A.pdf ? or what did you mean by sub folders?