looping through directory

  1. K

    Looping through a directory to generate a report

    Good afternoon. I'm hoping you all can help me (again). I have a directory that is a repository for forms created in excel. All the forms have the same format. Re repository may contain hundreds of forms in various stages of completion. A form is "complete" when all the required reviewers...
  2. N

    Loop thru Subdirectories find all .xls update value of specific cells

    Hello, I need code to loop thru all subdirectories open each workbook in the subdirectory that contains as part of the file name "_Sales Order.xls" and open each "_Sales Order.xls" and update worksheet "Sales Order Form" the following values: C44 new value = "00-440" D44 new value = " a few...
  3. 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...
  4. S

    Copying ranges from three worksheets in each workbook to master

    Hello, I'm new to VBA and am reading "VBA and Macros for MS Office Excel 2007" and "Excel with VBA & .Net" but do not as yet know how to tackle the following: I have numerous workbooks in a directory that I want to combine into a master workbook but why I am posting is because I haven't read a...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top