Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Iterate through files in a folder on Hard Drive
How do I iterate through file names in a folder on a hardrive? I already
have the code to set the Path and give me the name of ONE of the files....b ut I can't seem to loop through to all files in the folder: 'This code just keeps repeating the same file name in the folder yet there are 20 files in the folder. I need it to scroll through all 20 directory = "T:\Completed Models\" f = Dir(directory & "*.xls", 7) Do While f<"" Result = directory & f Loop |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HARD DRIVE | New Users to Excel | |||
Links to mapped drive change to refer to local hard drive | Links and Linking in Excel | |||
will this method clean deleted files off my hard drive for good? | Excel Discussion (Misc queries) | |||
Can I save to hard drive AND my flash drive at the same time? | Excel Discussion (Misc queries) | |||
Pasting a range of information from a foler on F Drive to another folder on same drive | Excel Programming |