Hire Freelancers

Automation in Excel - open to bidding - repost

$30-250 USD

In Progress

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.

Mobile App Development

Project ID: 5066453

About the project

3 proposals

Remote project

Active 10 yrs ago

Looking to make some money?

Email address

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:

I have worked extensively (10+ years) on Excel automation and vba. Currently, I am working for a multi-national company and programming is my hobby. I have worked on a similar requirements using the DIR() function in VBA which returns the filenames and then sort them on timestamp to pick the latest file. The last 3 requirements are very simple and can be easily achieved by basic VBA command. I hope you will award me the project.

$111 USD in 2 days

0.0

(0 reviews)

0.0

0.0

3 freelancers are bidding on average $264 USD for this job

Dear sir! I am ready to start. It'll be my honor to work for you. I'll do my best to complete the project on time.

$526 USD in 3 days

5.0

(22 reviews)

5.8

5.8

Flag of PAKISTAN

A proposal has not yet been provided

$155 USD in 3 days

3.6

(1 review)

2.7

2.7

Post a project like this

About the client

Flag of SRI LANKA

Kuliyapitiya, Sri Lanka

0.0

0

Member since Oct 27, 2013

Client Verification

Other jobs from this client

Copy all Contacts from a PDF File to an EXCEL Spreadsheet - repost

Similar jobs

Android Virtualization for Message Farming

Diamond Betting Exchange Website with Betfair API & Source Code

₹75000-150000 INR

Windows-Based Telegram Session Creator - 15/04/2024 17:18 EDT

Innovative Social Media App Development

Android App with Ktor

Food Catering Android App Development

₹12500-37500 INR

Android App Development

E-commerce Android App Development

mockup app per il cambio valute, prenotazioni hotel, tour, attività, ristoranti e integrazione con carte multi-valuta

I bought a smart watch kit from "Tiny Circuits" it uses Arduino. I need it to receive messages that I send from my phone.

Java App developer - Enhancement (1 week work)

React Native App Developer

₹600-1500 INR

Problems building a Xcode project -- 2

Flutter App Development with API

Android TV App Development with AI API Integration

Matka Gambling Android App Development

₹1500-12500 INR

React Native Developer for Cross-Platform App

₹1500-12500 INR

Anxiety Relief App with Focused Breathing

₹8000-10000 INR

UI/UX Designer with a Focus on User Engagement

₹1500-12500 INR

Technology Sector Lead Generation

₹600-1500 INR

Post a project like this

Thanks! We’ve emailed you a link to claim your free credit.

Something went wrong while sending your email. Please try again.

Loading preview

Permission granted for Geolocation.

Your login session has expired and you have been logged out. Please log in again.