2007 deprecatesfilesearch

  1. S

    Excel 2007 code for file directory loop - can't use Application.Filesearch

    Hello, I have been trying to process Excel files in a directory with the following code: Sub FindExcelFiles() Dim foldername As String Dim FSO As Object Dim fldr As Object Dim file As Object Dim cnt As Long foldername = "c:\users\bseagreen\desktop\TuesdayFeb102009\week ending feb 7...

Some videos you may like

This Week's Hot Topics