1. S

    Fast file search for most recently modified file

    Greetings, I recently threw together a bit of code that parses text from the most recently modified file in a selected folder. However, the folder keeps track of job tickets at my work, and it can fill up fairly quickly. Right now, 889 .txt files are in the folder to be searched. I have...
  2. K

    Using VBA/Excel to Search for Files in Windows Explorer

    Hi, I have a list of saved file names in descending order (without file type extension) Column A Column B File Name Link A1 A2 A3 A4 etc I would like to run a macro that searches for files containing the text of the file name (from column A) in a specified directory in windows explorer and...
  3. H

    I have a sub that works in excel 2003 but not works in excel 2007 error: With Application.FileSearch

    Dear friends. I have a sub in a macro excel, that works weel in 2003, but not works in excel 2007 or 2010, apper to depure when get the line : With Application.FileSearch . Thanks for any help. the sub is : Sub MostraPADTEC() Range("15:16").Select Selection.EntireRow.Hidden = False...
  4. R

    List All Files In A Directory Which Are Modified After A Certain Date

    I wish to create a macro that looks in a specific directory "D:Records" It finds the files which are modified after a date "January 01, 2012" in this directory (pdf files) Then it imports these files names into a worksheet Is this possible please??? Please Help...
  5. F

    Application.FileSearch 2003 - 2007

    Having recently got 2007 installed on my computer at work, it is apparent that Application.Filesearch is no longer available in VBA. Specifically; I need some code that will list the names of files in a folder in a column on my workbook. I have a fairly basic knowledge of VBA and although I...
  6. L

    fso - Microsoft Scripting Runtime Reference not working

    Hello! I have some code written that used to work fine in Excel 2007 once I added the Microsoft Scripting Runtime Reference. However, it is now giving me the same RunTime Error 5 with the debugger pointing me to this line of code: Set FSfolder = FS.GetFolder(sFolderPath) Is there another...
  7. L

    Need help modifying some FileSearch code please

    Hi, I'm a novice so please bear with me... I'm trying to modify some code from RDB to copy a range (one row, ~40 columns) from many workbooks (500+) into one. I just found out that the application.FileSearch which he uses has since been discontinued from Excel 2007+. I looked up a...
  8. J

    search for keywords in filename

    I am working on a small project and fairly new to vba, but managing alright with the guidance of many helpful people. Here's what I'm looking at. I have a workbook that saves a sheet to a new file for each client, the new filename contains the client name, a claim number, and the date it was...
  9. N

    Help with FileSearch VBA Code

    I'm a complete code novice - can someone help with two problems I'm having since upgrading to Excel 2007? I understand that FileSearch is no longer used in Excel - how can I rewrite this code to work? Private Sub CommandButton2_Click() Dim x As String Dim y As String Dim z As String z =...
  10. Jaafar Tribak

    Driving me crazy- FileSearch Object hunging the application during search execution !!

    Greetings all, The following code simply performs a file search on the C root using the FileSearch object. I set up the search criteria so that the file search takes a while in order to illustrate this problem. Sub test() Dim oFileSearch As FileSearch Set oFileSearch =...
  11. P

    filesearch excel 2003 to 2007

    Hello This works fine with excel 2003, but now I´m moving to excel 2007 and don´t know how to change "filesearch" code. Can anyone help me?? thanks in advanced _____________________________________ Private Sub Workbook_Open() Application.DisplayAlerts = False On Error Resume Next...

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