Paste multiple folder/file paths into excel using VBA

Originally Posted by sherlucky

Alphafrog,

Typically, when I link to spreadsheet in a network drive, I see the below:

='X:\Reports\eport\Account\2016\08\[08232016_POSITION_08242016_084619.xls]Cash Position'!$AF$12

As you can see, the file name is in brackets as it is being linked to a specific worksheet in that workbook. The addon you linked, does not bracket the file name.

So I was wondering whether there was a way to do just that.

When you say "Addon" are you referring to the code at this link?
List the Files in a Folder and SubFolders