I have cobbled together a macro that will pull all of the files from a folder into Excel. I would like to modify this macro so that a user can choose to only pull files names of a certain type into excel. (For example a user might choose to pull in only .pdf or .xlsm). I am at a loss as to what to do from here. Any help would be greatly appreciated. I apologize if my code is exceedingly juvenile, I am very new to this:
Please Login or Register to view this content.
Bookmarks