folders file listing

Hello all, I have done much digging in order to get this far but I'm still in little bit of a pickle. I am trying to make it so if a cell I have has a specific number form that it will save to a specific folder. In the Cell (L1) I have the date set as "mm-dd-yyyy hh-mm" and machine number ("11D...

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...

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...

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...

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) =...