Find Jobs
Hire Freelancers

Create Excel VBA/Macro for Find and Replace in multiple files

$10-30 AUD

Completed
Posted about 5 years ago

$10-30 AUD

Paid on delivery
I have 600 spreadsheets which need to have text replaced in each one. I need a simple VBA excel sheet that will automatically find and replace multiple text in each of the individual excel files. The VBA will need to open each excel file and perform a find and replace before saving the file with the updated text. Example below. 1. Opens all Excel files in a specified directory (let's say "C:\Temp" in this example). 2. In each file, finds every instance of a specified string (let's say "psi" in this example), and replaces it with another string ("MPa"), then replace "in" with "m", then "[login to view URL]" with "kNm" ... ... ... until all of the changes are made. 3. Saves and closes all the files, with the text now replaced. Similar example here: [login to view URL] Text that will need to be replaced can be found in the attached workbook
Project ID: 19107019

About the project

20 proposals
Remote project
Active 5 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 there, I am an Excel coder and I can do this macro for you in 30 mins. It's really simple. Please contact me, I will start right now.
$25 AUD in 1 day
5.0 (231 reviews)
6.6
6.6
20 freelancers are bidding on average $42 AUD for this job
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$70 AUD in 2 days
4.9 (545 reviews)
8.4
8.4
User Avatar
I have seen the project - Create Excel VBA/Macro for Find and Replace in multiple files. I have been working in these fields((Excel, Excel Macros, Excel VB Capabilities, Excel VBA)) for 7 yrs as a freelancer. I will never disappoint you and i will try my best to deliver good result always. Hope to work with you. Thank you.
$55 AUD in 3 days
4.8 (95 reviews)
6.7
6.7
User Avatar
I can help you. I have rich experience in excel and VB, and I do my best to save your time and pocket. Please feel free to contact me. MySkills: • Data Management ..............................{Excel, Matlab} • Programming ......................................{Java, C#, VBA, PHP, HTML} • Web designing......................................{Wordpress} • 2D Graphic ...........................................{Photoshop, Macromedia Flash, ...} • 3D Graphic ...........................................{3dsMax, Blender, ...} • Engineering...........................................{AutoCad, Watergem, SewerCad, Flow3D, Elvis, ArcGIS, ...} • Researching .........................................{Green Energy, Solar cells, WaterManagement, ....} Services: ? Accuracy ? Customer satisfaction is my first "Priority" ? Time Commitment ? Availability Thanks, Shahin
$30 AUD in 1 day
4.6 (67 reviews)
6.1
6.1
User Avatar
Hi Good Day! I've done a lot of work like this one before. I can help you to complete this project with high quality. I bid a higher amount becausethis is not an easy one. But I'll make sure to satisfy you. All future adjustment will be free of charge like warranty. With my experience as a VBA Macro developer for 8 years I can give you the high quality tool that can generate accurate result that you wanted using MS Excel. I am also a Project Management Analyst for 8 years in Accenture which given me the knowledge of creating quality dashboards and financial reports for our Clients. Please message me anytime to discuss more about this project. I am willing to help you out and show you my expertise. Thank you!
$100 AUD in 3 days
4.8 (84 reviews)
5.6
5.6
User Avatar
Hello, I can help you with this project, please send me a message with the file attached (in the post there are no file attached), so I can check it and start working on it inmediately.
$23 AUD in 3 days
5.0 (47 reviews)
4.6
4.6
User Avatar
Excel & VBA expert with the required skills. Can help to deliver a solution as needed & can start right away. Thanks
$35 AUD in 1 day
5.0 (18 reviews)
4.2
4.2
User Avatar
Dear Hiring Manager, I have read your project description of find and replacing text in multiple files and would like to offer my services. I have worked on several automation projects in Excel using macros. My expertise includes, but not limited to: Macros, Web Scraping, User Forms, Pivot Tables, Data extraction from PDF, Outlook, Access, etc. Looking forward to hear from you. Regards Chintu
$31 AUD in 2 days
5.0 (12 reviews)
4.1
4.1
User Avatar
Hi There, I am very much interested in doing this project. I am new here but having a very rich experience in this field. Please give me a chance to work for you. Please. Thanks
$150 AUD in 1 day
5.0 (10 reviews)
2.7
2.7
User Avatar
Hello ! My experience with vba is more than 10 years. Can You upload examples of xls files ? Thank You. Regards, Alexei.
$25 AUD in 2 days
5.0 (4 reviews)
2.3
2.3
User Avatar
Hi Sir/Mdm Thanks for reviewing my application. I am well versed in VBA having used it in various financial institutions. As I am a new freelancer, I am willing to do this job at a cheap cost or even for free. Please let me know your requirements. Regards
$10 AUD in 1 day
5.0 (7 reviews)
1.9
1.9
User Avatar
Can work with full dedication. can handle work pressure and a good team player. can provide support full time.
$72 AUD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Expert in excel and VBA programming, Can handle the project easily .Expert in excel and VBA programming, Can handle the project easily .Expert in excel and VBA programming, Can handle the project easily .Expert in excel and VBA programming, Can handle the project easily .Expert in excel and VBA programming, Can handle the project easily .Expert in excel and VBA programming, Can handle the project easily .Expert in excel and VBA programming, Can handle the project easily .Expert in excel and VBA programming, Can handle the project easily .Expert in excel and VBA programming, Can handle the project easily .Expert in excel and VBA programming, Can handle the project easily .Expert in excel and VBA programming, Can handle the project easily .
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have worked on many similar projects and should be able to deliver a robust tool.
$35 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have given my proposal and I can assure you that I will deliver the product as per the requirements
$25 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I believe in quality then quantity Relevant Skills and Experience Created HP reporting tools also by using macros
$45 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, Until i am building a portfolio on Freelancer, i take projects at the lowest price, it is not related to the quality of work. At my previous workplace i did similar tasks with master VBA Excel file. The attachment is missing, so i will need it to do the work. I can do it under 1 day. I hope we can work together. Best Regards, Staller Balázs
$10 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Client, I hope you are doing well! I understand you need an expert to create this Text Replacement Tool. I have created such macros in the past and this is easy, this will be 2-3 hours job for me. I am relatively new here at Freelancer but not new for such projects as I have 11+ years of similar experience working with multiple MNCs. Please review the work samples in my portfolio. With me, you get on time and accurate delivery, timely update, the SOP of the Process (if any), pleasant working experience, best Project Management as I am PMP certified Project Manager and Analytical & Solution Oriented Approach. I have a few questions like... How many sheets one spreadsheet is having? Do I need to replace in all the sheets or just in specific one in case of multiple sheets? etc. Let's discuss the requirement in detail. I am looking forward to a great association. Thank You Ajay
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Moorooka, Australia
5.0
48
Payment method verified
Member since Aug 7, 2016

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.