Need help! - Search Macro to retrieve a file from a subdirectory

Caveman1964

Board Regular
Joined
Dec 14, 2017
Messages
103
Hi!
I would like a search macro to retrieve a file from a subdirectory and the file will have a lot number with report on end and be a .xlsm. and then it retrieves it.
Example;
Click button for msgbox to ask what lot number
user enters it
then it searches through "L:\Job Packets"Product""Lot numbers""Lot number+report.xlsm"
real example
L:\Job Packets\WheelBarrel\123456\123456report.xlsm
User to enter 123456 and it gets the 123456report.xlsm

Thanks for any help on this.
if the msgbox is too much then he/she could just enter in a cell but prefer the msgbox from clicking macro. Either way will work.
Thanks
 

Caveman1964

Board Regular
Joined
Dec 14, 2017
Messages
103
So what about just a macro that retrieves a file?
I am working on this still don't have it working. If someone could get me started, I could possible figure it out.
Thanks!
 

Forum statistics

Threads
1,082,441
Messages
5,365,539
Members
400,837
Latest member
ELMST616

Some videos you may like

This Week's Hot Topics

Top