directory search

  1. P

    Search for file in userform and return directory and open pdf file

    Hi All, I have an urgent request. In a userform using Browsebutton, user will search for partial text in textbox then click browse. I would like this to open directory in " G: 'textbox.text'/ folder ", then user can open pdf/word/excel formatted files, in the applicable/relevant applications...
  2. Rymare

    Cell from Range, then set cell.value as Directory

    I have a userform that takes a mess of inputs from the user, and churns out a list of file paths for certain folders. You input a region, then a district (many districts in a region, then a city (there are many cities in a district), then the form lists all the atlases in that city (many atlases...
  3. C

    Automated Excel Workbook Updating

    Hi all, Please could someone assist with a project that I am starting? What I would like to do is create a program that will open (one at a time) all workbooks in a specific directory. Once open I need it to open and then close a number of other workbooks from another directory. The purpose of...
  4. L

    VBA Open most recent file LIKE in directory

    I've been at this for hours with google sending me to obsolete and older code that no longer works for office 2013. *sigh :mad: Ok, so I have a simple request. I need to look in Dir$("P:\path"), find most recent file of "Internal-EOM-201*" & ".xlsx", open it and define it for later reference...
  5. J

    Expert help needed to restrict directory search to date

    I have a current macro that is based on previously used macros. It is used for tracking incoming files that process downstream. The only major problem I have right now is trying to restrict the directory search to the current date (or the one enter into B4). Any help would be greatly...
  6. D

    Loop files in subfolders

    Excel 2003 I wish to loop through all subfolders, select Rps*.xls files, open them, perform some operations through a code, and save and close the files. Directory path: C:\Databank\MRP05\Protec\ Could someone tell me how this can be achieved?
  7. A

    How to know the Availability of a file in the directory?

    I have shared drive mapped to directory "M:\\". I have lot of folders and and subfolders in it. I want to run a macro which would search the folder name (Column A) in the directory and find the availability of the "Part of the File Name"(Column C)) and return Available/Not Available in Column...
  8. A

    How to search files from a directory with two keywords in file name???

    I have a shared drive mapped to directory "M:\\" I need to search a file from one of the folders in the directory. I'm able to list all the files from a folder in a excel sheet by specifying the path in the program. But I don't know how to search a individual file in the folder with two...
  9. G

    Marco Directory Search Problem from excel 2000 to 2007

    Hi i've just upgraded my Excel from 2000 to 2007 and now this macro have stop working Sub Dirlist() Dim i As Long With Application.FileSearch .NewSearch ' *** Change Folder name to suit *** .LookIn = "C:\My Documents" .SearchSubFolders = True...
  10. G

    Directory lookup with hyperlinks?

    Hi I have the Macro below that will search throught a directory and list the .Xls in it. What I am now trying to do with this is to create a hyperlink from the results that will take me right to the spreadsheet? Is there anything i can easily put in Thanks to anyone that can help :) Sub...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top