Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy file names
How can I copy the file names, within a folder, to another excel spreadsheet?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy file names
This little macro will list all the files in the folder that holds the
file that has this macro in it. Change the folder as necessary. HTH Otto Sub GetFileList() Dim ThePath As String ThePath = ThisWorkbook.Path fname = Dir(ThePath & "\*.xls") i = 1 Do While fname < "" Range("A" & i) = fname fname = Dir() i = i + 1 Loop End Sub "americana" wrote in message ... How can I copy the file names, within a folder, to another excel spreadsheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy of formula contains file names into other cells | Excel Worksheet Functions | |||
how can I copy file names into cells | Excel Discussion (Misc queries) | |||
Any way to copy file names in windows explorer & paste into Excel? | Excel Discussion (Misc queries) | |||
copy file names | Excel Discussion (Misc queries) | |||
need to copy a long list of file names | Excel Discussion (Misc queries) |