files in folder

  1. C

    Vlookup in vba

    Hi, I am new with the VBA, can someone help me, I have made this macro, but the loop across files in a directory runs only in cell G13, and I would like that, once it detects that the value is in a file, pastes it, and continues with the next cell. In other words, my macro result is the value of...
  2. K

    Using VBA code to all files in folder

    I want to extract, from the ID column, the Telephone using: <code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; white-space...
  3. S

    Print image files using excel Macros in Excel 2010

    Dear Friends, (step-1) I have a task to list down all the list all the files (file names) in a folder in one sheet in excel workbook. (step-2) then I am also supposed to print all the files listed as part of step -1 I am trying to achieve it by creating two buttons. (one for listing all the...
  4. D

    VBA - changing where files are drawn from

    Have found the following code on the 'Net and tweaked a little (with some help) to retrieve data from a number of workbooks in a folder, and then present it onto a new spreadsheet. Public Sub BattingRatings() On Error GoTo exitloop Path = "c:\Users\Dave\Desktop\IPL\" NextFile = Dir(Path &...
  5. S

    Read Files in folder Array function

    We have old Excel VBA function that creates an array of the files that are in a network folder. The files are then used in a report compiler to open and copy file contents into a big report. I am having an issue in getting the function to read the fold contents. This was written by a former...
  6. A

    I am creating a intricate ingredient counter to help with grocery provisioning.

    Here is how it will work... I create a bunch of meals in separate files; A few called "Roasted Tomato Bisque", "Spicy Gazpacho", "Greek Pastitcio", and many more. I will have a excel file called "foodWeek" that is a basic calendar of the week and each day will have a drop down menu. In this...
  7. M

    Assigning macro to each button to zip files dependent on button name

    I'm very new to VBA and programming and so I have no real idea how I can get around this problem that I have. Any help would be greatly appreciated! Sorry if it's difficult to understand exactly what I'm trying to do. If you need clarification on anything I will be online to answer any questions...
  8. C

    VBA code to open multiple files in same folder and perform same macros

    I have thousands of .fac files that i need to go through and format so that they will be able to be viewed by Diffmerge. I have macros already created in excel which will do all the formatting for me. Now i want to automate the process of opening each .fac file individually and selecting the...
  9. B

    VBA List File Info

    Help please, I am looking for a VBA code that will list files in a directory/subdirectory (entire tree) for each file under each subdirectory. For each file I want to know the following: *File Name *File Size *File Type *Date Created *Date Last Accessed *Date Modified *Permissions (List each...
  10. N

    E024.xls - Object doesnt' support this action

    I just bought "Office VBA Macros you can use today" and wanted to try a macro: "Creating a list of files that reside in a directory". I was disappointed to see that it choked at line 31: "With Application.FileSearch", with the error message: "Object doesnt' support this action". I am a beginner...
  11. T

    Mac Excel 2011 VBA: Merging xls files in folder

    I'm trying to use Mac Excel 2011 VBA to grab all .xls files in a directory and merge them. The trouble, however, isn't the merge algorithm; it's convincing VBA to properly identify and iterate through the files. I've tried a thousand things, but I can't get Excel to use the path to the folder...
  12. S

    Sharepoint library: VBA to loop through all files in library

    Hi All,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I spent hours looking through different means of looping through a SharePoint folder within Excel VBA to get details from the files there and then store them within a...

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