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 =...
    • lance01
    • Thread
    • folder open file search files in folder sub folder sub folders
    • Replies: 0
    • Forum: Excel Questions
  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...
    • Johnny2000
    • Thread
    • excel vba macro list files pdf count pdf page count sub folders
    • Replies: 2
    • Forum: Excel Questions

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
Back
Top