Quick VBA GREP on text / doc files

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


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'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.

Taidot: Excel, Excel VBA, Visual Basic for Apps

Näytä lisää: excel vba read text files, excel vba merge text files, vba generate doc files xls, vba modify text file, excel vba read text file into worksheet, vba open text file in notepad, how to extract data from text file to excel using vba, vba overwrite text file, excel vba find and replace string in text file, excel vba read text file line by line, open text file vba, microsoft excel, vba merge text files, vba merge text files file, upload doc files aspnet, vba convert text html, edit doc files, text pdf files php, php text pdf files, extract pictures text pdf files

Tietoa työnantajasta:
( 178 arvostelua ) Mississauga, Canada

Projektin tunnus: #15111717

Myönnetty käyttäjälle:


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,VB Lisää

$25 CAD 1 päivässä
(267 Arvostelua)

14 freelanceria on tarjonnut keskimäärin 42$ tähän työhön


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 Lisää

$50 CAD 1 päivässä
(216 arvostelua)

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. Nex Lisää

$83 CAD 1 päivässä
(145 arvostelua)

I have experience in Excel, VB,, 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 1 päivässä
(66 arvostelua)

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# usin Lisää

$30 CAD 1 päivässä
(40 arvostelua)

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 1 päivässä
(18 arvostelua)
$50 CAD 1 päivässä
(26 arvostelua)

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 1 päivässä
(15 arvostelua)

Excel VBA expert

$35 CAD 0 päivässä
(12 arvostelua)

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 automat Lisää

$26 CAD 2 päivässä
(10 arvostelua)

I read thrpughly your requirement n I can provide u vba code within a day. pls pm me. thanks mpunn

$30 CAD 1 päivässä
(9 arvostelua)

A proposal has not yet been provided

$55 CAD 1 päivässä
(3 arvostelua)

Excel, Visual Basic for Apps, Excel VBA

$35 CAD 1 päivässä
(0 arvostelua)

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 1 päivässä
(0 arvostelua)