Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Folder Contents to Excel
How can I copy (en mass) a folders contents, to show only the names.ext of
the files. I'll be using these names to create links in excel. I've tried the insert hyperlink, but it is too slow for all the work here and there are toooo many to manually type in. ie: \2006 \2007\ abc.pdf def.pdf ghi.pdf xyz.pdf lmn.xls My goal is to create an index of all 1500 or so files with working links to each file. Additionally, it would have to be updated weekly with new files. thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Listing Folder Contents into a Column | Excel Worksheet Functions | |||
Listing the contents of a folder | Excel Discussion (Misc queries) | |||
How can I insert the contents of a folder into Excel | Excel Discussion (Misc queries) | |||
To display contents of a folder in an excel sheet using Excel MACRO | Excel Worksheet Functions | |||
Exporting folder contents to excel or text format | Excel Discussion (Misc queries) |