| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to list file name and path in separate cells
Hello
Can anyone help me with a macro that will go to a particular folder in Windows explorer and list all the files in one column of an excel spreadsheet and the path to the file from that folder in another column. I need this to work on sub-directories so effectively creating an inventory of files and their paths. Any ideas or help will be much appreciated! All the best Redge |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro to list file name and path in separate cells
Redge,
Sounds like the free Excel add-in "List Files" will do what you want. Download from here... http://www.realezsites.com/bus/primitivesoftware Jim Cone San Francisco, USA wrote in message... Hello Can anyone help me with a macro that will go to a particular folder in Windows explorer and list all the files in one column of an excel spreadsheet and the path to the file from that folder in another column. I need this to work on sub-directories so effectively creating an inventory of files and their paths. Any ideas or help will be much appreciated! All the best Redge |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro to list file name and path in separate cells
That sound very useful Jim - I will give it a try many thanks!
|
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro to list file name and path in separate cells
It certainly does the job - how easy would it be to adapt the macro to
display the documents' built in properties alongside in addtional columns? Thanks Redge |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro to list file name and path in separate cells
Redge,
It would not be easy to add DocumentProperties to the List Files program. If you want a song list, John Walkenbach has a free workbook that will display all of your MP3 files and most of the information about them... http://www.j-walk.com/ss/excel/tips/tip103.htm If you actually want the document properties, then Chip Pearson provides the VBA code here... http://www.cpearson.com/excel/docprop.htm Regards, Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware wrote in message ups.com... It certainly does the job - how easy would it be to adapt the macro to display the documents' built in properties alongside in addtional columns? Thanks Redge |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| File Path - Macro | Excel Worksheet Functions | |||
| Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
| Pasting CSV list into separate cells... | Excel Discussion (Misc queries) | |||
| File Path Macro | Excel Programming | |||
| VBA - Reading the file name and path from cells | Excel Programming | |||
Hybrid Mode
