Find Jobs
Hire Freelancers

Write a program to automatically append tab files in different folders into Excel files

$30-250 USD

I përfunduar
Postuar almost 6 years ago

$30-250 USD

Paguhet në dorëzim
I have more than 5000 folders, in each of which there are three tab files. Each folder represents a company, and each company has three tab files: comments, fullstats, and statsperday. I need a program (VBA or something like that) to automatically grab tab files from each folder and append them together by their types. Not only that, I need the folder's name to be included in each data as a separate column. For example, the first folder contains data for a company called 2 K WEB GROUP, its comments data should be appended with other comments data in other folders, so should fullstats and statsperday data. And 2 K WEB GROUP needs to be the first column of the appended data. Final outcome will be three Excel files: comments_all, fullstats_all, and statsperday_all, each of them contains data from all 5740 folders in that type.
ID e Projektit: 17045465

Rreth projektit

37 propozime
Projekt në distancë
Aktive 6 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
I dhënë për:
Avatari i Përdoruesit
Hi, I am interested in your project and I can definitely get this done for you better, faster and more neatly than anybody else here. I have an enormous amount of experience in programming and also working with data files and received excellent 5 star ratings for my previous work. Your requirement is quite clear to me but I would like to discuss further to get a better idea of your folder structure and how you want the merging to be done for the 3 files. * Do you have any special reason to use VBA for this? I personally wouldn't use VBA to do this as you would be dealing with a large number of files. I recommend using a standalone VB.Net or C# program or even Python. But I am more than willing to do it in VBA if you insisit. By the way, my schedule is clear right now to start working on your project immediately, so please get back to via project chat if you are interested. Thanks and I look forward to get this job done for you.
$100 USD në 3 ditë
5,0 (55 përshtypje)
6,5
6,5
37 freelancers are bidding on average $127 USD for this job
Avatari i Përdoruesit
Hi there, Can I see samples of the excel tab files? I have a 99% project completion rate and a 4.99 reputation (out of max 5.0 from more than 1120 projects over 11 years. Thanks. I look forward to hearing from you Best Regards, Rajesh Soni.
$244 USD në 3 ditë
5,0 (995 përshtypje)
8,8
8,8
Avatari i Përdoruesit
Hello, I can help with you in your project Write a program to automatically append tab files in different folders into Excel files. I have more than 5 years of experience in Data Processing, Excel, PHP, Software Architecture, Visual Basic. We have worked on several similar projects before! We have worked on 300+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$250 USD në 3 ditë
4,9 (407 përshtypje)
8,1
8,1
Avatari i Përdoruesit
I will create script to combine all three types in comments, fullstats, and statsperday from each folder and include folder name column inside the excel file. I will complete this work in 2 days. Looking for your reply to start this work immediately. I will be available online from 2 am GMT to 5 pm GMT individual full-time freelancer.
$67 USD në 2 ditë
5,0 (1210 përshtypje)
8,1
8,1
Avatari i Përdoruesit
I can create simple GUI program that will allow you to select root folder and output files location. After you click Start button it will process each subfolder in root folder, parse comments, fullstats, and statsperday files and append that data into main output files. I can start right now and complete it in next 15 hours for just $100 and all I need to start is some sample data from you.
$100 USD në 1 ditë
5,0 (526 përshtypje)
7,5
7,5
Avatari i Përdoruesit
Hello, My name is Chrys. As you can see from my profile, I have 17+ years experience working with Excel/VBA and 13 years teaching them both (all levels). I can certainly do excellent work with your project. Please contact me to further discuss the details. Looking forward to hear from you, Kind regards, Chrys
$190 USD në 2 ditë
4,9 (98 përshtypje)
6,8
6,8
Avatari i Përdoruesit
Hello Sir, I am experienced excel developer. I can help you with this to get those 3 files within 6h looking to hearing from you soon .
$111 USD në 1 ditë
4,9 (147 përshtypje)
6,5
6,5
Avatari i Përdoruesit
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. Willing to take up your project. Thank you, Regards.
$75 USD në 1 ditë
5,0 (123 përshtypje)
6,5
6,5
Avatari i Përdoruesit
Hello there, This looks feasible and I can do this quickly. I have developed more than 500 VBA macros for Windows/MAC I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. Ping me to discuss project , timeline and budget. Thanks A
$94 USD në 1 ditë
4,9 (177 përshtypje)
6,5
6,5
Avatari i Përdoruesit
I am proficient with macro/VBA development, I can write the macro to append and categorize files into specific workbook as per your specification, feel free to message me if you are interested, looking forward to chat further and work on your project.
$80 USD në 1 ditë
5,0 (107 përshtypje)
6,3
6,3
Avatari i Përdoruesit
Hi, I think I can do it!:-) I have a lot of experience in Excel and Visual Basic data processing. Best regards:-)
$155 USD në 3 ditë
4,9 (72 përshtypje)
5,8
5,8
Avatari i Përdoruesit
Hi there!I am a professional Software developer and Excel CSV Expert. I have developed many software that combine data from other files into csv files etc. Message me and if you want to discuss your project details with me. i can finish your work in very short amount of time.
$100 USD në 3 ditë
5,0 (30 përshtypje)
5,3
5,3
Avatari i Përdoruesit
Hi, I am ready to convert those tab files(csv files) into excels. Put those files into any drop box and share with me. You will get your final three excel in a day. The tool will be based on Java. You will get the source code after completion. Regards Debashish
$155 USD në 1 ditë
5,0 (8 përshtypje)
5,1
5,1
Avatari i Përdoruesit
Hi, as your project brief, I think I have an idea to help you. What i need is your folder list and your raw concept about how the excel file will looks like. I'm waiting for your reply. Thank you.
$50 USD në 3 ditë
5,0 (44 përshtypje)
4,6
4,6
Avatari i Përdoruesit
I have done a similar project some time ago. Contact me to talk about that and maybe send me an example. Depending on the way you would like to execute this, i could write you an app that you simply drop the files into and it will generate you the desired excel file. best regards Sebastian
$155 USD në 3 ditë
5,0 (3 përshtypje)
4,7
4,7
Avatari i Përdoruesit
I worked in many projects with VBA, most of them for web scraping, dashboard, forms. I have the required expertise for your project.
$155 USD në 7 ditë
4,9 (17 përshtypje)
4,4
4,4
Avatari i Përdoruesit
Hi Sir, if you provide me the samples i can start your task within 3-4 hours. Thanks in advance
$111 USD në 1 ditë
5,0 (13 përshtypje)
4,5
4,5
Avatari i Përdoruesit
Hello, the offer includes maintenance and future, minor changes. I would be happy to do that project for you. Best regards, Michael
$111 USD në 6 ditë
5,0 (13 përshtypje)
4,5
4,5
Avatari i Përdoruesit
Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now
$61 USD në 3 ditë
4,7 (31 përshtypje)
4,5
4,5
Avatari i Përdoruesit
Hello, I am an expert in programming with Excel and VBA with experience in data management. I am your best option. Let's do it !!! Best regards.
$50 USD në 5 ditë
5,0 (1 review)
1,7
1,7
Avatari i Përdoruesit
Hi, I'm new to Freelancer and am looking to build a good reputation here. I just need to be given an opportunity. I have a versatile skill set working with data and data tools. I would love to do this in vb as quick as possible for you.
$138 USD në 2 ditë
0,0 (0 përshtypje)
0,0
0,0

Rreth klientit

Flamuri i UNITED STATES
Sprngfield, United States
5,0
1
Mënyra e pagesës u verifikua
Anëtar që nga dhj 11, 2017

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.