files in folder

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

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

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

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

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

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

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

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

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

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

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

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