| 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 |
| 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 | |||
Threaded Mode
