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.
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 en 1 día
4,9 (267 comentarios)
7,1
7,1
14 freelancers están ofertando un promedio de $42 CAD por este trabajo
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
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
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
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
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.
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