list files

Hi Guys, Anybody knows how to list all the PDF Files from a Folder and its Sub-folders to the Excel with VBA? Thank you

I have used this to list files in folder, but now want to only list files with do not contain a worksheet "TEST" can anyone help please? To go one step further I would move the files which do not have worksheet TEST to a new subfolder "NO TEST" Thanks in advance *********** Sub List_Files()...

This bit of hobbled together VBA from various sources lists all files in the selected directory. They are sorted alphabetically, then enumerated in Column 1, which is also a hyperlink to the folder the file is in. Column 2 is the filename, which is a hyperlink to the actual file. Works great for...

Hi Excel Experts http://www.mrexcel.com/forum/excel-questions/73458-read-external-file-properties-date-created-using-visual-basic-applications-2.html I am taking a list of files in a network folder and using the code in the above link. Since, the folder has large number of files the code stops...

I need to be able to list all files in all folders and subfolders in a particular drive (I use this macro to populate three different tables depending on the drive, so thus the mytbl and myPath variables. I also have it set to use a named range to determine whether or not to include...

Hello all! I am new at VBA, so any help is much appreciated. Here is a summary of what I'd like the end result of this project to be: When I open Workbook A, Macro #1 automatically runs as the file is opening. This macro will analyze the contents of the "Seed Folder" (through Windows...

Hi, I would like to list all files in a specified folder. The files are placed in the following folder: "\\nodc01\ssa\Utstyr\Dokumenter\" & Me.Internnr" so that it will show different file content depending on what's selected/opened. I have inserted a list and added this code (found here...

I am trying to create a macro that looks at a list of hyperlinks to other excel files in a master excel and pdf's the print area in each file. Another member of this site has helped me to get this far: Sub Macro1() 'below is the selection Range("B2:I16").Select 'the below command will save...

I am looking for a macro that i can assign to a master excel sheet that will recognise the **hyperlinked files * already in the file and print a certain sheet with the print area to a printer of my choice. How would i go about doing this? i have tried a number of macros i have seen online but...

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

Hi all, I'm trying to figure out a way to list only the first level of folders in a file structure. I'm accustomed to using the GetFolder method but how to do only one level is the question. For instance, if I had the following folder structure: C:\Base C:\Base\FolderA C:\Base\FolderA\Folder1...

I'm fairly new to vba for excel and I need a little guidance on a macro that I've pieced together from multiple web sources (pasted below). I've search for a couple of days, and nothing I've found gets me what I want. The macro loops through files in a specific directory and sums values from...

I'm searching for certain files on a specified, referenced drive in Worksheet("Parameters"). These files have to be last modified before a certain date and the search should not locate certain files in specified, referenced folders. The goal of this project is to collect "stale files," and...

I am trying to list all based based on the last accessed date ans show file name, date created, modified, and accessed. As well as give a file count. I have gotten the code to work for a specific folder, but cannot figure out how to modify it to list the files in any subfolders. The code I...