I need a vba run excel file manager to be drafted with following functionality:
1/ list file names from the selected folder + subfolders
2/ list location of the file
3/ hyperlink to the file
4/ once list is generated, ability to change file names in the list that would automatically change names in selected folder and subfolders. So basically I am doing a sanity check of the files, when I spot an error in the naming convention I want to be able to change the name in the list (next column for example) and after clicking a button name of the file is changed and list is refreshed and fixed name now appears in the fresh list.
I am just a beginner so up to this point I have managed to create something barely working. But my macro would only change file names within the folder, and not subfolders. Since I am not able to spend more time learning to do it, I need help.
Further functionality required:
1/ button to extract data to excel and pdf format
2/ in macro every function described in plain english with comments, so I can learn
And there might be few other small additions that I forgot.
So all in all, easy quick project
After this project, there is another one I might need help with
Thank you for your time !!
Hi Sir/Mdm I am a new freelancer and I am willing to do for minimal cost or even for free as I am looking only for positive reviews. Please let me know how I can help Regards
23 freelancere byder i gennemsnit €26 på dette job
Hi... I just did a file scanner using macro. I think from what you want I can do it quickly. What I need is just your reply then I'll send you a concept. Then you can decide. I'm waiting your reply. Thank you.
As your requirements I'm willing to work for you. My ultimate goal is to provide you a quality product that enhance your business. I assure you i will work most efficient and effectively. Thanks Aartsol
i am working as a Secretary so i am good at using Microsoft word,excel and so on. i can help you finishing this task with my experience (4 months) with low budget and high accuracy.