VBA Code to split cell's text data

Hey Team,

I have a macro that give file location in Column F. I want to split cell's data of column F between last two backslash. First splitted data should go to Column E and last to column A but without .xlsx. Location format would be same for all entire column F.

Also column A is a name and there is a email database in sheet "Email ID data" . We also need to identify email ID for each of entry in column A.

I have attached sample sheet. Please look into this for reference. Please help on this.

Thanks,
Liz