Find Jobs
Hire Freelancers

Automation in Excel - open to bidding

$30-250 USD

Completed
Posted over 10 years ago

$30-250 USD

Paid on delivery
I need an experienced Excel Programmer to develop an automation/vb script to do the following. 1. Import a txt file from a specified location (with the most recent timestamp) - which is in a format as listed below - YYMMDDXXXXX,TXT 2. Delete contents of last 2 Columns except last row (the number of rows may change from file to file) 3. Change Column C format to a Custom format of 16 zeros 4. Save file in format Company_Name (which will not change) - MM-DD-YYYY (2 days prior to date found in txt file) and save as Excel 97/2003 format.
Project ID: 5066148

About the project

37 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello there. I have high Excel and Visual Basic skills with great professionalism. I study electronics and computer engineering at Oporto university and I'm looking for work to fill the blanks on my schedule. I'm experienced with this type of codes and I can deliver it today. Is it possible to view the .txt files before accepting your project in order to understand better your project requirements? I'm very interested on your project and I would gladly appreciate this opportunity to work with you. Best regards, Bruno Martins
$30 USD in 1 day
5.0 (59 reviews)
5.4
5.4
37 freelancers are bidding on average $84 USD for this job
User Avatar
Hello - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have zero failed projects since I don not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. I will provide you with a working version of file before you award me the project. Thanks, Jay
$55 USD in 3 days
5.0 (647 reviews)
8.3
8.3
User Avatar
I'd be happy to write the macro for that, and can start as soon as you are ready ---------------------------------------------------------------------------------------------------------------------
$45 USD in 1 day
4.9 (250 reviews)
7.6
7.6
User Avatar
Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.
$80 USD in 0 day
4.9 (325 reviews)
7.6
7.6
User Avatar
Hello; your 5-star excel and vba coding expert is ready to help your macro project. I had many similar tasks, all achieved with 5/5 rating, pls check my profile and feedbacks....ready to go ahead, upon your confirmation...regards,
$45 USD in 1 day
4.9 (262 reviews)
7.7
7.7
User Avatar
Hi, Let me help you with this. Could you send me a sample file of source file and output file? I can work on this and send you the result in a day. Looking forward for your quick reply. Regards, Susanto
$30 USD in 1 day
5.0 (58 reviews)
6.4
6.4
User Avatar
Its hardly two hours work for experienced Excel developer...I have great experience in excel coding and complete this script within 2 hours....Lets start
$34 USD in 1 day
4.9 (221 reviews)
6.6
6.6
User Avatar
I'm a Microsoft certified developer with 18 years of experience. I can do this for you. Because of the nature of the work you have mentioned, I would recommend using OpenXML to do this, rather than doing this as an Excel program. Language can be VB if you require it to be (I presume so, based on your project description). If you still want it to be done as a Excel VBScript, I can do that as well
$247 USD in 30 days
4.7 (4 reviews)
5.9
5.9
User Avatar
Hi, this is really easy project for me. I can provide you complete solution in few hours and I'm sure you'll be impressed with my work. I'm talking about standalone GUI program where you can select source TXT file (or files), hit Start button and the program will create result Excel file in the format you need. Thanks. Roman
$35 USD in 1 day
4.9 (84 reviews)
5.7
5.7
User Avatar
I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files and hosting command buttons and other controls if necessary. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards
$35 USD in 20 days
4.9 (62 reviews)
5.7
5.7
User Avatar
VBA Excel expert with 100% Repeat Hire Rate I can make this very fast. Please check my reviews and portfolio as proof of my expertise.
$78 USD in 3 days
4.9 (34 reviews)
5.3
5.3
User Avatar
Hi, I am expert Excel VBA/VB programmer. I have already worked on such type of projects. I can come up with demo version for you if you provide some sample data. If demo version looks good then you can select me as service provider. Thanks and Regards, manishadk
$35 USD in 1 day
4.8 (15 reviews)
4.0
4.0
User Avatar
Hello, I have very good experience with such data processing and can do this quickly. Please let me know if vbscript is a requirement or if a vb.net console application would be ok as well. Also, please be aware that you need to have Excel implemented on the machine, where the processing is done. Otherwise saving in Excel format is not supported by the programming language. Kind Regards, Mathias
$50 USD in 3 days
4.6 (3 reviews)
3.7
3.7
User Avatar
Hello, Automation expert here. Can complete your requirement in a day. However, allocated 3 days just to be safe. I take up projects only if I am confident of finishing them successfully. A few questions: 1. Are the files gong to be read from a local hard drive, or a web location? 2. Are they currently in CSV(comma separated or any other delimiter) format? (Although they are .txt) Send me a sample file if interested. Best regards, AccuPro.
$150 USD in 3 days
5.0 (5 reviews)
2.8
2.8
User Avatar
Ready to work on this.. please assign to me. will deliver project with in time. looking forward to work with you
$55 USD in 1 day
5.0 (1 review)
0.6
0.6
User Avatar
I have built numerous excel macros for my current company. (Over 50) And I have done much more complicated and difficult functions in Excel. Your best excel tool will not only work functionally, but will be easy to use and will work FAST - anybody can build slow excel tools. You need experience to figure a way to make the tool work FAST and make it easy to use. Proposal - 1. You will be given one button in an excel sheet which you will have to click. This button will perform all the functions you have mentioned from step 1 to step 4. 2. After you click the button, the file in format Company_Name (which will not change) - MM-DD-YYYY, will automatically get stored in the same location where the original txt file was. This job needs around 8-10 hrs of work. Thanks Abhishek
$111 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I can deliver the VB script with good quality and without any bugs. Best Regards, Saravanan
$111 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Completed.. Hi every thing is complete other than the 3rd point mentioned. It is unclear for me. Rest of the things are done including the name of the file to be saved with. Let me know if you can award me this project. Anyways its now 95 % complete. Let me know for any negotiation.
$33 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Expert on excel program is my added advantage and able to do the excel database program very well. Familiar with data entry and be able to source data from internet google yanoo etc...familiar with internet market marketing because I am agen Affiliate. Please consider and I will deliver the best.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am good at MS Excel and an expert with Excel Macros and VBA. I have developed many apps etc similar to the job required
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Indianapolis, United States
4.8
2
Payment method verified
Member since Oct 25, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.