Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA codes to get dates of files in a folder
I was using these lines of codes in EXCEL 2003 to get files names and dates
in a folder, they do not woork in EXCEL 2007. Any new codes or modification I can use Set obFileSearch = Application.FileSearch With obFileSearch .LookIn = "C\:Temp\" .Filename = "*.xls" ' 'True, files were found If .Execute 0 Then 'Enter file names in spreadsheet For iCounter = 1 To .FoundFiles.Count Cells(19 + iCounter, 7).Value = .FoundFiles(iCounter) Cells(19 + iCounter, 8).Value = FileDateTime(.FoundFiles(iCounter)) Next iCounter End If End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling pdf files from general folder to specific folder | Excel Discussion (Misc queries) | |||
Creating a unique list of Cost Codes in Col. A from all worksheets in all workbooks in folder X | Excel Programming | |||
User selection of folder and open all .xls files within folder | Excel Programming | |||
how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Discussion (Misc queries) | |||
how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Programming |