របៀប Copy ឈ្មោះ ឯកសារទាំងអស់ពី Folder ដោយងាយស្រួល ប្រើប្រាស់ Code || How to list all files' name (មានវីឌីអូ ខាងក្រោម)
Excel is awesome! But with so many people using Excel in large companies, the number of spreadsheets used can become quite massive. Keeping track of all these can become a job in itself.
I worked at a large insurance company and we were in the midst of a project to take inventory of all the spreadsheets used.
We created a VBA procedure that would take a folder path and spit out all the file names in that folder. Each department was responsible for using this to take inventory of all their files. Fortunately for me, my department used only a few folders and subfolders for our work otherwise I would have tried to modify the code to loop through all subfolders in a folder.
We were using Excel 2010 and installing the Power Query add-in was not an option due to IT security lockdown. With Power Query, this would have been a much less time-consuming task, and with no coding needed.
1. Go to the folder and select all (Ctrl+A) the files that you want to get the name list.
2. Use" Ctrl+Shift+Right Click" and select on Copy file part, and past to the Excel Program
3. In Excel Go to data--> Text to Cullom
Watch this video for clear.