Thread for opening trusted location and show text files only

[chugi]

Hi every one.

I am very new to VBA and have just started exploring macros.

I have a monthly activity to extract a text file inventory listing into excel. When i program the macros for opening the file, I select the text file available in the folder but, this file name may change month on month. Also, i need to select all files to see this text file and it doesn't show in the initial dialogue box.

Would much appreciate a thread to allow me a dialogue box showing a selection of the text files (for respective months inventory listings) after selecting which, I may proceed with the next steps of the macro.

My apologies if this has been covered elsewhere in the forum.

Thanks.

 

[Micron]

Not sure if I understand, but it seems you could use the msoFileDialogFilePicker and set its multi select property to true in the process. That would allow you to raise a file dialog (looks like Windows File Explorer) and loop over the chosen files to do whatever it is you have in mind with those selections.