Get file name from selected file in File Explorer

[mark hansen]

I've set up a workflow where the users needs to log selected information from a system generated file name. Currently they single click twice on the file name (within File Explorer) and copy that file name into the clipboard.

Then I have a VBA routine that when run, takes the information from the clipboard, and pulls out just the needed information (last Name, First name, Date) and enters that information into the last line of a table. Works great and not too bad of a work flow, considering what they were doing before. (hand jamming each letter).

I'm wondering if I can have the code just looked at the selected file and do the same thing (end up with the last name, first name and Date in the column)?

So is there a way to... user selects the file in file explorer, hit a button in excel and (same as above), pulls the file name, parses it out into needed information, and put in the table.

Thanks,
Mark

 

[bobsan42]

Excel can call it's own filedialog and then get the selecteditems names.
Trying to figure out which of the system file explorer's windows contains the file you need will be close to impossible in the general case.

 

[mark hansen]

Ummm, thanks for the idea. Hadn’t thought about selecting during the routine, just before.