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

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

Készségek: Adatfeldolgozás, Excel, VB.NET, Visual Basic, Visual Basic for Apps

Bővebben: simple excel vba, excel vba code optmization, excel vba code optimis, vba read text file into array, vba edit text file, how to extract data from text file to excel using vba, vba close text file without saving, excel vba read text file into worksheet, vba open text file for reading, excel vba find and replace string in text file, copy data from text file to excel using vba, excel vba code log websites, simple excel vba open external program, excel vba code ftp, excel vba code update, excel vba code open internet explorer, inventory excel vba code, optimizing excel vba code, optimize excel vba code, excel vba code check add ins

A munkaadóról:
( 58 értékelés ) Victoria, Canada

Projektazonosító: #17586338



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 rep Több

$20 USD 0 napon belül
(100 értékelés)

9 szabadúszó tett átlagosan $25 árajánlatot erre a munkára


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 0 napon belül
(126 vélemény)

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 Több

$25 USD 0 napon belül
(103 vélemény)

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 0 napon belül
(69 vélemény)

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 organizi Több

$30 USD 0 napon belül
(31 vélemény)

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 compl Több

$30 USD 1 napon belül
(24 vélemény)

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 Több

$24 USD 1 napon belül
(1 Visszajelzés)

I am very honest and Sincere thanks.

$25 USD 1 napon belül
(0 vélemény)

Hi I am syful .i am dataentry expert.I have seen your job post and read description carefully. You want to do dataentry. I have interested in this job . I have good experience on dataentry work.I have complete Több

$20 USD 1 napon belül
(0 vélemény)