Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I just switch from Windows XP to Windows 2007 and I'm no longer able to run
this macro. Can you help me... Thanks ----------------------------------------------- Sub ListFiles_01() 'Using FileSearch to list the files in a directory Dim i As Integer i = 1 With Application.FileSearch 'This is the problem' ..NewSearch ..LookIn = "C:\" ..Filename = "*.*" .SearchSubFolders = True '.SearchFolders = True ..Execute For i = 1 To .FoundFiles.Count Range("B" & i + 1).Value = .FoundFiles(i) Range("C" & i + 1).Value = FileDateTime(.FoundFiles(i)) Range("D" & i + 1).Value = FileLen(.FoundFiles(i)) 'Range("E" & i + 1).Value = Filename(.FoundFiles(i)) Next End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
want to record date for each time I update a file - Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 protected file corrupt after update | Excel Discussion (Misc queries) | |||
Excel cell can't update link in the file in sharepoint 2007 | Links and Linking in Excel | |||
Update back to shaprepoint list from dowloaded Excel file | Excel Discussion (Misc queries) | |||
Excel 2007 - Sharpoint 2003 can't update list on server | Excel Discussion (Misc queries) |