Find Jobs
Hire Freelancers

Build a custom function in VBA for Applications (MSWord and MSExcel, all versions)

$30-250 USD

In Progress
Posted over 7 years ago

$30-250 USD

Paid on delivery
I want a custom 'Find & Replace" function that will work in any version of MS Word or MSExcel for Windows. The industry I work in has some unique words that are always misspelled or and abbreviated incorrectly, so I will pay to have some custom VBA code written to do the following. In a open MSWord document or Open MSExcel Workbook click on an icon that opens the new function and either highlight and select some text (or cells) and run the 'Custom Find & Replace' function or run against the entire document. If the work or phrase is not found the user would be able to add the a new correct word or phrase and replace the word or phrase in the open document. If there is more than 1 possible replacement the VBA function will allow the user to select the one he or she likes best. I want the correct words or phrases to be stored in a text file or other simple file that can be sync'ed to a company server and then be merged to a 'Master Find & Replace' file then after the merge the New "Master Finder and Replace' file will be pulled down from the server to the local computer to be used. I can do the interface design and you can provide the VBA code behind. I can also fill in the unknowns like the path to the server and such.
Project ID: 11904374

About the project

8 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
$30 USD in 3 days
0.0 (0 reviews)
0.0
0.0
8 freelancers are bidding on average $152 USD for this job
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$150 USD in 5 days
4.9 (42 reviews)
6.2
6.2
User Avatar
Greetings! My name is Sergey Murzin, I'm from Kyiv, Ukraine. I have 20 years experience with MS Excel/Access/VBA: databases, finance, statistics, accounting, CRM etc. Any code I provide is well structured and commented, client gets whole access and rights for the code I made. Warranty covers any bugs detected later. Looking forward for further clarifications of the details. Regards, Sergey
$145 USD in 5 days
4.9 (4 reviews)
2.6
2.6
User Avatar
Hi, i can help in this project, the idea is i will create a custom tool using VB.net once you open it you have to select the Word/Excel file you want to do the search on, and of course specify the word and the replacements in external txt file. please let me know more about this project.
$155 USD in 1 day
5.0 (1 review)
0.8
0.8
User Avatar
I have read your job specification and I am pleased to submit my proposal. I am an Microsoft Office VBA coder with over ten years experience in developing automated, time saving apps. Off the top of my head, I believe the VBA code for WORD and Excel written for Office 2003 will work in all versions of Office. I will test the code in versions 2003 and 2015. The macros will be coded to read in a text file to read into memory the Find and Replace options and to add new user defined values. Your comments are welcomed. Regards Zenon
$155 USD in 3 days
0.0 (1 review)
2.8
2.8

About the client

Flag of UNITED STATES
Liberty Lake, United States
5.0
1
Payment method verified
Member since Sep 10, 2003

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.