folders file listing

  1. O

    Obtain Folder Names from a Windows Folder Directory

    Thanks in advance. What do I need to adjust to get the folder names to paste into the Worksheet “Raname.Folders” as I am getting the message “No folders found!” I believe the issue is with the following lines of code, but I am not sure how to fix them: 'Store the directory...
  2. R

    fso.GetFolder(myDir).Files.Count - 1 'Why is -1 needed sometimes, not always

    Folks: Scenario: 2 departments, 1 macro for each: Why is "-1" needed for one group of files and not the other? Because of Temporary files?: File count accurate for Department 1 reports with: fileCount = fso.GetFolder(myDir).Files.Count - 1 but for Department 2, I had to remove the -1...
  3. srizki

    Folders

    It is not really an excel question, but it is relevent. I want to create some over 200 folders name "Moveable Assets" under each of existing folders. I will have to to to each folder and create one. Is there a way to create all folders at the same time? like highlight all the folders and go to...
  4. G

    Get Files Macro Need more

    Hi i've got this Marco/Function Sub get_files() Extension = "*.CSV" Folder = "C:\Documents and Settings\User\My Documents First = True RowCount = 1 Do If First = True Then FName = Dir(Folder & "\" & Extension) First = False Else FName = Dir() End If If FName <> "" Then Range("A" & RowCount) =...

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