Find Jobs
Hire Freelancers

Quick VBA GREP on text / doc files

$10-30 CAD

Completed
Posted over 6 years ago

$10-30 CAD

Paid on delivery
If you know VBA for Excel, this one is very easy and probably only will take you 1 hour. We need a quick Find and replace GREP function. It should work on the following files: 1) .TXT 2) .DOC, .DOCX, .XLS, .XLSX 3) .PHP, .HTML (these are straight text files) 4) Basically any filetype that's just plain text (should have the ability to add to a list the different file types) The program would launch from Excel. It would have 5 user inputs: 0) Check boxes of the file types (listed above) which we are looking to replace - default is all checked. 1) Folder picker (launches cmddialog that allows the user to pick a folder, default folder should be in a constant somewhere in the code) 2) string to replace 3) the replacement string 4) Include subfolders check box Hit a button and it asks if you are sure then it goes through each of the file types selected above indicated above and replaces the string in 2) with the string in 3) and does that for every file in the chosen folder. If include subfolders is checked, it will go through each subfolder as well. That's it...it's just replacing ONE text string. This is NOT a sql query, it's a straight TEXT replacement *** it should be able to handle different characters as well such as quotation marks, ampersands, dollarsigns etc. NOTE: ALL the program functionality and logic is located in this description, there is nothing more that will be asked. Thanks for your bid.
Project ID: 15111717

About the project

14 proposals
Remote project
Active 7 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 , I have read your project description and understood your requirement. I have 5 years experience in Excel VBA and can develop application,Scrap Data etc. Relevant Skills and Experience Skills : Excel, Macros,VBA,VB.net, Web scraping, Data entry, Copy typing, Transcription works Proposed Milestones $25 CAD - Project
$25 CAD in 1 day
4.9 (267 reviews)
7.1
7.1
14 freelancers are bidding on average $42 CAD for this job
User Avatar
Greetings sir, i can help you in Find and replace GREP function via VBA and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have more than 5 years of experience with excellent knowledge in Excel and VBA. please give me a chance to work on your project Proposed Milestones $50 CAD - Once the project is complete
$50 CAD in 1 day
4.9 (216 reviews)
7.3
7.3
User Avatar
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. Lets discuss more online on chat. Thanks, Abhinav
$83 CAD in 1 day
4.9 (145 reviews)
6.3
6.3
User Avatar
I have experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Relevant Skills and Experience EXCEL VBA Proposed Milestones $55 CAD - excel
$55 CAD in 1 day
5.0 (66 reviews)
6.0
6.0
User Avatar
I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Relevant Skills and Experience VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application Proposed Milestones $30 CAD - VBA
$30 CAD in 1 day
4.9 (40 reviews)
5.3
5.3
User Avatar
Hi, I'll code that GREP function accordingly you"ve listed. Relevant Skills and Experience vba, Excel Proposed Milestones $55.56 CAD - default
$55 CAD in 1 day
4.8 (18 reviews)
5.1
5.1
User Avatar
I would like to take this one and do the same . Relevant Skills and Experience VBA Proposed Milestones $20 CAD - final and can be negotiable
$20 CAD in 1 day
4.9 (15 reviews)
4.4
4.4
User Avatar
Excel VBA expert
$35 CAD in 0 day
5.0 (12 reviews)
4.4
4.4
User Avatar
I have read the project description and ready to work on it. Relevant Skills and Experience I have recently closed 4 projects in Excel using VBA. I am a professional with 10 years experience and have worked on automation, reports and dashboards in excel. Proposed Milestones $26 CAD - Find and Replace Function Please confirm the operating system and excel version you are using.
$26 CAD in 2 days
5.0 (10 reviews)
4.1
4.1
User Avatar
I read thrpughly your requirement n I can provide u vba code within a day. pls pm me. thanks mpunn
$30 CAD in 1 day
5.0 (9 reviews)
3.2
3.2
User Avatar
A proposal has not yet been provided
$55 CAD in 1 day
5.0 (3 reviews)
2.0
2.0
User Avatar
Excel, Visual Basic for Apps, Excel VBA
$35 CAD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Here I can provide you windows form application.. As you said it will work accordingly Relevant Skills and Experience C# programming Proposed Milestones $5 CAD - Accept the task $30 CAD - Complete the task
$35 CAD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Mississauga, Canada
5.0
178
Payment method verified
Member since Apr 19, 2007

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.