Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Filenames AND details to Excel
Below is some code that I use to get display the filenames from directories
into excel. However, it only brings in the filename...how can I also get the details portion of it...namely the modified date? Any ideas. Thanks in advance Sub AllFilenames() Rem Change D:\ to your folder path D = "C:\MY FILES\" Cells(1, 1) = "Filenames" r = 2 f = Dir(D, 7) Do While f < "" Cells(r, 1) = f r = r + 1 f = Dir Loop End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Type details into one cell and they copy into another | Excel Discussion (Misc queries) | |||
Macro for copy pasting details from main sheet | Excel Discussion (Misc queries) | |||
Copy row details where cell value meets certain criteria | Excel Worksheet Functions | |||
using excel to rename filenames? | Excel Discussion (Misc queries) | |||
How do I copy subtotaled data without the underlying details? | Excel Worksheet Functions |