sub folders

  1. D

    Vba to cycle through sub folders and perform functions on excel files

    hi everyone, I have a folder with subfolders that have excel files in them. I am trying to have a vba loop go through each of the sub folders, extract the value from Cell F1 from a specific sheet and then paste that value into another workbook. a couple of roadblocks: 1.) each folder has a...
  2. C

    run macro on files within sub folders as well as in root folder

    I have some code that opens all excel files within a folder and copies cells from these files into a master recording spreadsheet. However, I have now been told that the source files will be saved within individual sub folders within this root folder. The code works perfectly for the root...
  3. V

    VBA - MS Excel, modify code to include files in sub-folders as well

    I have the following VBA macro, and I am using it to create a log by extracting certain values from a list of excel files in a particular. However, instead of just the files in <code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida...
  4. L

    Search through folders and subfolders to find a file and open it.

    Hi I have started this macro but I am having a problem (Labeled '????? below). I am tring to find a file which is typically .doc/docx/.pdf within a folder or its subbfolders then open it if found. Can anyone modify my solution below to to alos searchthrough all subfolders? file =...
  5. C

    Display folder name in Excel - VBA Macro

    Hi, I need a macro which displays the folder and subfolder name from a specific path in the column A of the excel sheet in the same heirarchy. Also whenever a sub folder name is displayed in column A, I need its main folder name to be displayed in the same row Column B i.e offset(0,1). I have a...
  6. J

    Recursive search in nested folders/subfolders and then open file

    Hello, I have been searching for a solution to a problem for quite some times now, and I was hoping one of you have a great idea in this forum. I first like to appreciate any help and any reply to my problem. My problem is, I have an excel macro that does multiple thing for a report purpose...
  7. J

    how to Search Sub Folders - Help Please

    Hi, I a newbie to VBA and not got much further than creating userforms (but totally addicted) and i am desperate for some help. I have some code below which i need modded to search sub folders as well. Can someone pleae help me and it is greatly appreciated. At least advise if it is possible...

Some videos you may like

This Week's Hot Topics