Simple Excel VBA code - read text file, quick edit, then save text file

$10-30 USD

Completed

Posted

over 5 years ago

$10-30 USD

Paid on delivery

Very simple requirements: 1) create excel vba code that will open a text file (e.g. [login to view URL]) 2) code will then do the following: 3) look for person's name in the line (e.g. Dr. FirstName Last Name) 4) remove the firstname and leave only Dr. LastName) 5) save text file without any further edits [login to view URL] - SHOWS YOU THE INPUT FILE (sample) [login to view URL] - SHOWS YOU HOW IT SHOULD LOOK once the Macro is run (first name and middle name eliminated, only shows Dr. LastName) Please bid only if you can complete today: August 16th 2018

Visual Basic for Apps

Project ID: 17586338

About the project

9 proposals

Remote project

Active 6 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:

@sourabhg98

Hello! This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer currently at the post of Forum Expert at [login to view URL] (username - sourabhg98) with over 400 questions answered and 1100 reputation points. I would like to offer my services for this project. I can easily build a macro for editing the doctor names from the text files as dscribed by you. Can complete now within couple of hours at most. I assure the best in class services and fairest prices. Do consider me once, won't disappoint you. Would wait for a positive and prompt response from your side :) Regards Sourabh

$20 USD in 0 day

5.0

(100 reviews)

5.4

9 freelancers are bidding on average $25 USD for this job

@customizedata

I can do it in one hour. Please clarify a bit about the field name separator . Is it ~ sign ? Looking forward to have a chat with you to discuss further.

$30 USD in 0 day

4.9

(126 reviews)

6.5

@periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered twenty four excel vba projects in the past one twenty days. Sure. Will complete in a few hours. Willing to take up your project. Thank you, Regards.

$25 USD in 0 day

5.0

(103 reviews)

6.2

@Ahmed818

Hello, sir i have great experience in this kind of jobs please check my profile and reviews i can write this VBA code and finish it within 2 hours can start now waiting your answer Thank you

$19 USD in 0 day

4.9

(69 reviews)

5.1

@jasalaz100

Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizing and analyzing any company variables. Experience on programming with VB in excel, creating any report using pivot tables and pivot charts, dashboards.

$30 USD in 0 day

4.9

(31 reviews)

4.9

@paulodayto08

Hi, Good Day! I am a PMO Analyst and my primary task is the creation of Financial Reports. I am exposed on different excel formulas and functions. I am also a VBA Macro developer which I think a big plus to complete this project. You can check my reviews to help you decide. Feel free to message me anytime to discuss this project. Thank you

$30 USD in 1 day

5.0

(24 reviews)

3.7

@saiko1953

greetings,your project caught my attention we can cooperate together that i know WORD and EXCEL from A to Z Also have very good experience as a data entry i will provide you with accurate work within short duration u can trust me and will be satisfied.............regards

$24 USD in 1 day