subfolders

Hello Professionals, I need your advise regarding enhancing the current macro. Currently I have the below code (recursive method) to copy contents of the excel files from the a set folder only as shown below. But I am trying to create a non recursive method to copy the contents on the all the...

Hi All, I currently have the following macro which makes all files in a particular folder read only: Sub setFileReadOnly() Dim sPath As String Dim sFile As String sPath = "C:\Users\tp\Documents\B\*.*" sFolder = Dir(sPath & "*.*") Do Until sFile = "" SetAttr...

Hi, I am trying to write a macro that will copy a subfolder structure to multiple folders within a directory on the network. What I have are folders such as C:\Test\Folder 1; C:\Test\Folder 2, etc. What I want to do is copy the same set of subfolders in a different directory to...

For the last year I have been downloading cash register X1 and Z1 files onto an SD card. Each night's files (X1 & Z1) are stored in a new folder with the naming convention "RP + [DATE]", (EX: RP120910, [YYMMDD]). I have 265 folders!!!<br><br> I need to go through each folder, select the Z1 file...

Hello all and thank you in advance for any help you can give. My overall goal is to have a MasterLog worksheet that contains summary data from individual files. There will regularly be subfolders added and individual excel files within those subfolders. The individual files are all formatted...

i made a drop down menu in excel, hence is there a way to make a drop down menu of sub folders with the check box next to it, and once the option is being selected to show only the ones being selected? For example: I have a Solution option to choose from where I have options of Eastern...

Hi I am hoping someone can please help me. I would like to select a Main Folder and the Macro to then list all SubFolders and Files (within the SubFolders), including the date last modified. Please help. Thanks in advance MarkAn

Forgive me if this is covered somewhere else, I've looked around but it seems to be fairly specific. I have a list of customer part numbers that I would like to search for the corresponding file in a folder and subfolders. (the pdf print of a sheetmetal part for example). The files will often...

Hello, I have been searching for many hours for a VBA-code in Excel for 2010 for the following. I want to open the last saved closed Excel-file that can be found in a folder and its subfolders. It has to open just one file in the folder or in one of its subfolders. It should find and open e.g...

Hi, I've mixed and matched the code below to allow the user to browse and select a file in any folder. The macro then loads the filename of all files contained in that folder. The code does not however load file names in the subfolders. Could the formula be amended to include subfolders...

Hi, i have found a macro online which works almost perfectly Option Explicit Private cnt As Long Private arfiles Private level As Long Sub Folders() Dim i As Long Dim sFolder As String Dim iStart As Long Dim iEnd As Long Dim fOutline As Boolean arfiles = Array() cnt = -1 level = 1...