B bhasoriya Member Apr 15, 2013 #1 A column has file name. B column has to be folder path. For example: I have one folder, in it there are too many folder and it has files too in it. if i find as *.* in folder then i can get the all file name list, but how can i get the path details in excel? Please help me.
A column has file name. B column has to be folder path. For example: I have one folder, in it there are too many folder and it has files too in it. if i find as *.* in folder then i can get the all file name list, but how can i get the path details in excel? Please help me.
Hui Excel Ninja Staff member Apr 15, 2013 #2 Bhasoriya Have a read of my comments and SirJB7's comments which detail 2 different ways in this post: http://chandoo.org/forums/topic/automatic-listing-path-of-pictures-in-cell-for-merging-data-in-indesign You'll have to modify as appropriate
Bhasoriya Have a read of my comments and SirJB7's comments which detail 2 different ways in this post: http://chandoo.org/forums/topic/automatic-listing-path-of-pictures-in-cell-for-merging-data-in-indesign You'll have to modify as appropriate
dan_l Active Member Apr 15, 2013 #3 Data explorer (http://www.microsoft.com/en-us/download/details.aspx?id=36803) also does this out of the box.
Data explorer (http://www.microsoft.com/en-us/download/details.aspx?id=36803) also does this out of the box.