Excel file manager

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

Dear all,

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 !!

Data Processing Excel Software Architecture Visual Basic

Project ID: #17503005

About the project

19 proposals Remote project Active 5 years ago

Awarded to:

stanleyw12

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

€8 EUR in 1 day
(8 Reviews)
2.1

19 freelancers are bidding on average €25 for this job

SBITServices

Hello , I have read your project description and understood your requirement. I have 5 years experience in VBA and can do changes and add the functionalities required. I can complete task within ti More

€30 EUR in 1 day
(491 Reviews)
7.8
TonmoyRoy111

Dear Client, I understand the scope of work. I have vast experience in excel and I have previously carried out a number of projects in excel using macros and formulas. I an certainly help you out in this project. Ki More

€50 EUR in 2 days
(507 Reviews)
7.5
TechnoGuruu

Hi, I have checked your project details and it's very interesting. : ) I have many years of experience in Excel,data analysis, pivots and VBA macros etc. I have finished many projects. Please give me this opportun More

€50 EUR in 5 days
(97 Reviews)
6.5
The24CarrotsInc

Greetings for the day!! We have experience working on this subject. We ensure 100% QUALITY with ON-TIME Deliveries. Please allow us to take this opportunity. Thanks & Regards, Team@The24CarrotsInc VBA/EXCEL More

€30 EUR in 1 day
(79 Reviews)
5.9
vsprybhanu

Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I can access any folder and subfolders and rename the files automatically through vba programming. I have done it bef More

€30 EUR in 1 day
(139 Reviews)
6.2
nurnga1218

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.

€29 EUR in 2 days
(46 Reviews)
4.7
raselkm22

Hello Thanks for giving me a chance to participate in your project. I have read the project description and got the main point of what is desired! I’ve vast of knowledge on research. I have done it previously and now More

€28 EUR in 1 day
(2 Reviews)
4.6
RemonRamzy04

Hello, sir! (First Bidder to offer this) I hope I will be awarded from you. ************I agree for any price you will set ** You can test me over chat before you award me! give it a try over chat before you award More

€12 EUR in 1 day
(18 Reviews)
4.4
SunniaImran

Hi Here is the right person you are looking for. I am willing and ready to take up your project right away. I am sure that I can do it within your required time and format. The client satisfaction is always my prim More

€23 EUR in 1 day
(12 Reviews)
3.8
aartsolutions

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

€8 EUR in 1 day
(1 Review)
1.4
Jaatboy315

Yes i m doing Relevant Skills and Experience Mob +918630831874

€23 EUR in 1 day
(0 Reviews)
0.0
vinothvijayy

I am join to job

€23 EUR in 1 day
(0 Reviews)
0.0
atulmdsarkar11

Dear Sir, I have read the job post carefully. I have done several projects like this but new in freelancer.com .I have confidence that I will do your work very well. I hope you would like my work. So if you give me c More

€23 EUR in 1 day
(0 Reviews)
0.0
svgames72

Hello sir/Madam, I read your project description. I would like to work on your project. I'll finish that job and that too for 1 day. And my typing speed was 40 wpm. Please access my profile for more details. Regar More

€8 EUR in 1 day
(0 Reviews)
0.0
christinanagy22

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.

€23 EUR in 2 days
(0 Reviews)
0.0
preethama47

Hello, The way you have explained is appreciated. I feel the work is challenging too. Could you please share me the file,I will have a look. looking forward to work with you. Thank you

€8 EUR in 7 days
(0 Reviews)
0.0