Search and retrive

kevinchurchill

New Member
Joined
Jul 20, 2015
Messages
26
Hello,
I have a problem in that I have found a template with code that searches folders and sub folders for selected file types
and returns the file path, date last modified etc. then in the last column it generates a link to the file, this is great
for me but not for my collegues, the problem for them is that they must first go through the FileSystemObject.
As we only need to search one fixed address folder that has many sub folders that are named with a four digit number, each subfolder
represents a machine, so using a text box and a command button to execute the search I would like to modify the code to search whatever
subfolder number I input and return the files in that subfolder with hyperlinks.
please feel free to follow the link below to access the file with code, I have added additional text boxes within the file to try and better explain.


thanks in advance for your help.


https://www.dropbox.com/s/mfgcxdeldfxctrb/SEARCHE DAM.xlsm?dl=0
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

kevinchurchill

New Member
Joined
Jul 20, 2015
Messages
26
Hello
Thanks for you’re reply,all the functionality I need is already in the linked to file in my post, i just need to modify the search method ie, i want to input the folder number in the text box and use a command button to execute the search.
As there is only one folder with many sub folders to look in it will simplify the process.
Thank you.
 

kevinchurchill

New Member
Joined
Jul 20, 2015
Messages
26
Sorry i meant to say the MS browser object, thats the one I don't want to use I want to use just a search box of my own making to search for sub folders in a fixed location.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,049
Messages
5,526,488
Members
409,703
Latest member
nbkqsj7

This Week's Hot Topics

Top