Find Jobs
Hire Freelancers

Excel Macro for listing file name and it's all its properties in excel sheet in given directory

₹12500-37500 INR

Закрито
Опублікований over 6 years ago

₹12500-37500 INR

Оплачується при отриманні
We have many types of files such as image, video, excel, word, audio etc. and it's numbers are too many . we wish to give directory name in one of the cell and than macro should list the properties for each types of files in each each sheet (one sheet for Image files, one for Video one for Audio etc.) listing the file name and all it's properties in one row. Than we should be able to run another macro the summaries this listing grouping them year wise month wise and day wise giving total against each year month and day .
ID проекту: 15548701

Про проект

22 пропозицій(-ї)
Дистанційний проект
Активність 6 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
22 фрілансерів(-и) готові виконати цю роботу у середньому за ₹18 172 INR
Аватарка користувача
Hi there, I have a script that pulls the file from the folders and can be modified as per your requirements easily. I have written many scripts in Excel VBA. I'm an excel VBA expert with over 5+ years of experience. Ping me to discuss more about project, timeline and budget. Thanks Aman
₹13 333 INR за 1 день
4,9 (181 відгуки(-ів))
6,6
6,6
Аватарка користувача
Hi, I have already developed a macro to access file names of any specific folder and can add properties value of that file. So, can do this job nicely. Relevant Skills and Experience Experienced Data Analyst and Macro Developer. I have done mostly Excel VBA Programming job. Proposed Milestones ₹4000 INR - initial ₹4000 INR - second ₹5888 INR - final
₹13 888 INR за 3 дні(-в)
4,8 (145 відгуки(-ів))
6,1
6,1
Аватарка користувача
I am Postgraduate in Financial analytics (MBA). I have expertise in MS Office automation tools, advanced Excel, VBA, and financial analytics. currently working for an US based banking institution . you can get your work done in low price with higher quality of work. please have a look at my portfolio to get understanding of my previous projects.
₹12 500 INR за 2 дні(-в)
4,9 (51 відгуки(-ів))
5,9
5,9
Аватарка користувача
I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Relevant Skills and Experience -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application Proposed Milestones ₹15555 INR - VBA
₹13 332 INR за 4 дні(-в)
4,9 (68 відгуки(-ів))
5,7
5,7
Аватарка користувача
I've done number of projects using excel visual basic coding. I can work on your project. Relevant Skills and Experience MS Excel, Visual Basic, Macros Proposed Milestones ₹20000 INR - Upon Completion For further details about me kindly review my profile.
₹20 000 INR за 5 дні(-в)
4,6 (37 відгуки(-ів))
5,3
5,3
Аватарка користувача
Could you please provide more details about this work if you are happy with the proposal, I can able to do this one but I would like to know some sample folders with sample files that will help me Relevant Skills and Experience VBA Proposed Milestones ₹12500 INR - final payment
₹12 500 INR за 5 дні(-в)
4,9 (28 відгуки(-ів))
5,0
5,0
Аватарка користувача
The best way to manage your data is storing it in a sql server database (express) I can build a desktop or a web based application to manage your data Habilidades y experiencia relevante I'm an expert in .Net technologies and SQL Server. I have been working in software development for the last 20 years I'm a specialist in web solutions and desktop applications Htos propuestos ₹27777 INR - Milestone
₹27 777 INR за 10 дні(-в)
4,9 (37 відгуки(-ів))
5,2
5,2
Аватарка користувача
Greeting, I have understood your Excel Macro for listing file name and it's all its properties in excel sheet in given directorytask and can do it with your 100% satisfaction. Relevant Skills and Experience I have more than 5 years of experience in Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps Proposed Milestones ₹27777 INR - Excel Macro for listing file name and it's all its properties in excel sheet in given directory
₹27 777 INR за 10 дні(-в)
4,8 (14 відгуки(-ів))
5,3
5,3
Аватарка користувача
Excel expert with extensive vba and programming experience. I can help you with your spreadsheet. Relevant Skills and Experience I have worked for several years in excel and perform daily work using vba, user forms, pivot tables, formulas, etc. Proposed Milestones ₹13000 INR - Two milestones. One at the midway point of the project. ₹14777 INR - Final milestone at the end of the project Additional Services Offered ₹1 INR - I would start by committing to 10 days but this depends on the scope and could change I have an extensive background in Excel. I would love to know more about your project.
₹27 777 INR за 10 дні(-в)
5,0 (2 відгуки(-ів))
4,0
4,0
Аватарка користувача
Dear Hiring Manager, As understand, you would like to captured file properties of different types of file in a separate sheet for each file. For this you would like to specify folder name to browse through each file automatically. I have experience working on similar projects and currently available to work on your project. I am a professional with extensive experience in excel and have worked on variety of projects including web scraping data extraction from PDF and Outlook. I'm sure you would be happy if you hire me. Looking forward to hear from you. Regards Chintu
₹21 111 INR за 3 дні(-в)
5,0 (11 відгуки(-ів))
4,1
4,1
Аватарка користувача
Hello, I have read your requirements and able to provide complete solution of your requirements, will write perfect macro as per your requirements withing your budget. Thanks Mahesh Relevant Skills and Experience I have 3.5 years experience of Software development and Macros using VBA along with other technologies too. Proposed Milestones ₹12500 INR - Complete Project
₹12 500 INR за 7 дні(-в)
5,0 (16 відгуки(-ів))
3,4
3,4
Аватарка користувача
I have a lot of experience with VBA. I have checked the requirement and understood it properly. Relevant Skills and Experience Excel, VBA, Macro Proposed Milestones ₹20000 INR - Complete Job
₹20 000 INR за 4 дні(-в)
5,0 (1 відгук)
2,8
2,8
Аватарка користувача
Hi, I read your request. From your description, I can deduce that you need an excel file to search a directory, get all the files, categorize the files by extensions, give the details of the files found and be able to provide some summary based on some sets of macros. I am well versed in using MS Access and Excel to automate tasks using macros, forms, queries and reports. I can provide you with either an Excel file or an ms access file based on your description. I am also a new member here so be rest assured that I will give my best to deliver a quality app within the shortest possible time. Thanks.
₹12 500 INR за 5 дні(-в)
4,0 (4 відгуки(-ів))
2,9
2,9
Аватарка користувача
A proposal has not yet been provided
₹13 888 INR за 5 дні(-в)
5,0 (2 відгуки(-ів))
2,4
2,4
Аватарка користувача
Design:------------ (1)These properties can be loaded into an Excel sheet: Path, File Name, Last Accessed, Last Modified, Created, Type, Size (2)SUB DIRECTORIES also will be scanned (3)Summary generated in another sheet Relevant Skills and Experience:------------- 15 plus years of IT systems development for SWIFT(Virginia), Unisys Corp(London), HSBC bank(Hong Kong) & BHP NZ Steel(New Zealand). No job is small as freelancing is my hobby now. Degree from IIT Additional Services Offered:--------------------- ₹1000 INR - I will do an audit and make suggestions to improve your Excel system. ₹2000 INR - My estimate of effort to implement the suggestions Question: ---------------- Are these fields sufficient ? Path, File Name, Last Accessed, Last Modified, Created, Type, Size
₹12 500 INR за 2 дні(-в)
5,0 (3 відгуки(-ів))
1,5
1,5
Аватарка користувача
I have been working every day with Excel: formulas, databases, reports, and VBA for the past 10 years. Relevant Skills and Experience Excel: formulas, databases, reports, and VBA Proposed Milestones ₹20000 INR - Excel file Additional Services Offered ₹500 INR - Custom button on home tab to run the macro time & again
₹20 000 INR за 10 дні(-в)
5,0 (2 відгуки(-ів))
0,7
0,7
Аватарка користувача
i am madheswaran is data entry job is full time is complete work. Relevant Skills and Experience i am a 3 years experience for this project Proposed Milestones ₹12500 INR - i am good job is ms office the data entry ok
₹12 500 INR за 7 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
Sir hire me good in these type of work
₹27 777 INR за 10 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
A proposal has not yet been provided
₹14 814 INR за 10 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
Sir I know you will get lots of bid here. this is an simple excel problem I can solve it creatively. I am a new user here. Can you please give me a chance to do this. you won't be disappointed. I need money very badly.
₹12 500 INR за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор INDIA
Hong Kong, India
0,0
0
На сайті з жовт. 30, 2017

Верифікація клієнта

Інші роботи від цього клієнта

Mobile wifi on Pi connected with 10TB+ Hard disk
₹12500-37500 INR
Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.