Dr. Demento
Member
At the bottom of the code, there's a commented out code (see thread VBA file listing (1 of 3) for attachment | Private Sub HyperlinkFileNames()) that is designed to create hyperlinks to each of the files listed. I'm trying to merge the original listing code with this new hyperlink creation code.
The goal is that the hyperlink code will use the filepath already chosen by the file dialog (Set objFolder = objFSO.GetFolder(strPath))instead of having to re-identify the desired filepath. The problem is that the strPath is defined earlier but won't transfer into this sub. I'm a noob, but I thought that defined variables were available throughout a module, even if they were defined in a private sub.
Additionally, I would like if the hyperlinked filename shows just the filename with the hyperlink being "invisible" - like normal hyperlinks are
Thanks for any thoughts/tips y'all can provide.
The goal is that the hyperlink code will use the filepath already chosen by the file dialog (Set objFolder = objFSO.GetFolder(strPath))instead of having to re-identify the desired filepath. The problem is that the strPath is defined earlier but won't transfer into this sub. I'm a noob, but I thought that defined variables were available throughout a module, even if they were defined in a private sub.
Additionally, I would like if the hyperlinked filename shows just the filename with the hyperlink being "invisible" - like normal hyperlinks are
Thanks for any thoughts/tips y'all can provide.