macro to input folder name to get data

[fastballfreddy]

I have a code to input date of file for it to open (start of the code below).

I have a main folder called Data that has folders for each previous day's date. I want a code that i can input the folder's name that is in Data to then input the file name of the file in that folder. For example in the Data folder I have a folder named 07-09-2024. I want to input that folder name in a popup box to then grab the file in there.

 Sub data()
Dim Loc As String
Dim Nme As String
Loc = "D:\Trackers\Data\Review"
Dim Result As Variant
Result = InputBox("Input date MMDDYY", "Date Picker"(
Nme = "Tracking Log " & Nme & ".xlsx"

 

[Micron]

Are you aware of the file dialog boxes named msoFileDialogFilePicker or msoFileDialogFolderPicker? Better than an input box IMO. If you will only have 1 file in a folder the first one would be better for you. If multiple files in a folder need to be dealt with, the folder picker might be better suited.

 

[fastballfreddy]

Thanks! Yes a couple of weeks ago I used it for the first time. After testing a few codes I was able to get what I needed. Thanks for the advice!

 

[Micron]

Glad I was able to help, and thanks for the recognition.