extract name and copy the location

The location is the same for all files as there are in the same folder ...is it?
Why to put the file name in column G as it exists in column H,I,J,K ?
Can we store the path of the folder somewhere ?

Dear PCI
yes, all files contains in same folder and same location, C:\Users\Pervaiz Iqbal\Desktop\All Files\
i want file name in column G due to as you see the there is some column are behind we will fill the some info as follow the column G, (specially name and mail ID), you can use the any criteria for column G accordingly to H,I,J,K...



Adeel

Thinks seems more clearnow, try next code.
To be launched from the sheet where results must be

Please Login or Register  to view this content.

Dear PCI
i have folder path C:\Users\Pervaiz Iqbal\Desktop\All Files\...all the files are in it, in code i did not see that where i put the folder path to get the result...if i just make run it just pick 4,5 files name in column G form destop and didn't show location

Adeel

It assumes that the file "Work sheet Help.xlsm" with the macro is in the same folder that the files to treat.
Else how would you like to mention the folder path ... a message box or others ways , please explain.

Dear PCI

i got your point, now i move that file in that folder and i have results, some issue that some of file name are ending with (.,/\)code not showing there location but they are in column G and similarly file with (.png) showing in column G but not not showing path in said column, and some of files are macro based(word and excel) also not showing location but that is in column G, please look

Adeel

Can you send me some examples of files' name with difficulties.
Of course for Excel you have to prepare 2 columns

like: MGA INDUSTRIES PVT. (either this is word or excel or pdf)
you can see there is dot in end, this type of files are showing in column G but location is not appearing in concern cell and column & all those files which saved with macro enabled..

Adeel

What is the full name?
MGA INDUSTRIES PVT.docx
MGA INDUSTRIES PVT.pdf
I have no concerns
An issue could be if there was several . in the file name, is it the issue ?
See next code

Please Login or Register  to view this content.

In the code sent see the selection done versus the file extension

Please Login or Register  to view this content.

For example:
if the file has the "DOCX" extension (Word file ...?) it will be recorded in column I
What do you mean by " ended with (dot)", please give an example .. a file name cannot finish by a dot ...!

dear PCI

like file name (Verification Covering Letter.) above code is not mentioning the location of word files...for excel and pdf files code is working..means i have 3 files of word docx in folder, doc name is showing in column G but location is not showing

Adeel

Dear PCI
i got it, can we add some like (means) doc and docx (for both in same column) as well under below code, if i want, will it work

means like

Please Login or Register  to view this content.

i made some changes in above code than run this is working for me, just confirm if i will made changes like this any change required in remaining code or this is enough to change here..

Yes it is exactly what you have to do: You got it

You are welcome

Hello adeel1,
Because you modified the code, it will be good that you attach the last one from you.
Else you can remove next statement which is cleaning up the sheet

Please Login or Register  to view this content.