
In Progress
Posted
EXCEL VBA / MACRO CONSULTANT REQUIRED – ONGOING SUPPORT & DEVELOPMENT We are looking for an experienced Excel VBA / Macro developer to take over the maintenance and development of an existing macro-enabled Excel workbook. The workbook was developed internally and is an important part of our business process. We need someone who can understand an existing VBA application, troubleshoot errors when they occur, and add new functionality as required. This is NOT simply an Excel spreadsheet job. We are looking for someone with strong VBA development and debugging experience who is comfortable taking over code written by another developer. INITIAL PROJECT The first stage will be to review and understand the existing workbook and provide an assessment of its structure, dependencies and maintainability. The work will include: • Reviewing the existing VBA code and macro structure • Understanding how the workbook and macros operate • Identifying potential problems or fragile areas • Troubleshooting any existing errors • Checking compatibility with current Microsoft Excel / Microsoft 365 • Reviewing external links, references, files, add-ins or other dependencies • Reviewing UserForms and automated processes where applicable • Making recommendations to improve reliability and maintainability • Adding appropriate documentation/comments to the code • Advising on a suitable backup/version-control process ONGOING WORK Following the initial review, we would like to establish an ongoing relationship with the successful freelancer. Future work may include: • Fixing VBA/macro errors • Modifying existing functionality • Adding new features • Developing new macros • Improving the performance and reliability of the workbook • Supporting changes arising from Microsoft Excel/Microsoft 365 updates • Providing advice on possible improvements or automation REQUIRED EXPERIENCE You should have substantial experience with: • Microsoft Excel • Excel VBA • Macro development • Debugging and troubleshooting VBA • Taking over existing/legacy VBA applications • Modifying code written by another developer • Excel formulas, tables, named ranges and data validation • VBA UserForms, if applicable • Microsoft 365 / current versions of Excel DESIRABLE ADDITIONAL EXPERIENCE Experience with any of the following would be an advantage: • Power Query • SQL • Microsoft Access • ODBC/database connections • Power Automate • Excel-to-database integrations • Git or other version-control systems • Modernising older VBA solutions IDEAL CANDIDATE The ideal candidate will have previously inherited a complex Excel/VBA workbook developed by someone else and successfully taken responsibility for maintaining and enhancing it. You should be comfortable working with an existing system and understanding how it works before recommending changes. We are not looking for someone who will automatically suggest rebuilding the workbook from scratch. We value careful, structured development and want changes to be made without disrupting existing functionality. APPLICATION Please provide: 1. Examples of relevant Excel/VBA projects you have worked on. 2. Details of your experience taking over existing VBA/legacy Excel applications. 3. Your experience troubleshooting complex VBA errors. 4. Your hourly and/or daily rate. 5. Your availability for ad-hoc ongoing work. 6. Your location/time zone. 7. Any relevant qualifications or certifications. Initially, we expect to engage the successful freelancer for a review of the existing workbook. If the relationship works well, we would like to retain the freelancer for ongoing troubleshooting, maintenance and development work.
Project ID: 40717515
102 proposals
Remote project
Active 1 min ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
102 freelancers are bidding on average €16 EUR/hour for this job

Hi there, I understand this project requires taking ownership of an existing Excel/VBA application, understanding how the current macros, UserForms, dependencies and automated processes work, and then maintaining and improving it without disrupting existing functionality. I’m confident I can approach the workbook systematically, diagnose issues at code level, and make controlled changes rather than recommending an unnecessary rebuild. My approach is to first audit the workbook structure, VBA modules, UserForms, named ranges, formulas, external links, references, add-ins and database/file dependencies, while tracing the main workflows and identifying fragile areas. Then, I’ll troubleshoot existing errors and test compatibility with current Microsoft 365 Excel, documenting the findings and refactoring areas where reliability or maintainability can be improved. Finally, I’ll establish practical documentation and backup/version-control procedures and provide a clear roadmap for future enhancements. You’ll receive the initial technical assessment, VBA/code review, dependency analysis, identified risks and errors, compatibility findings, recommended improvements, documentation/comments, and ongoing support for future development. Could you confirm whether the initial review will be performed on the live production workbook or a separate working copy? I’m available for ongoing ad-hoc support and can work within your required business hours. Warm Regards, Aneesa.
€12 EUR in 40 days
7.0
7.0

Hi, I understand you need a VBA specialist to take ownership of an existing macro-enabled Excel application, understand its architecture, and maintain it without disrupting established workflows. I will review the VBA modules, UserForms, dependencies, external links, and compatibility with Microsoft 365, then document fragile areas, troubleshoot errors, and recommend practical reliability improvements before implementing future enhancements. A few questions: * Can you share a sanitized copy of the workbook and any known error messages for the initial assessment? * Does the workbook rely on external databases, add-ins, network files, or other linked workbooks? * Are there existing backup or version-control procedures, and would you prefer Git-based tracking or a structured Excel backup process? Best regards, Muhammad Usman
€15 EUR in 40 days
7.0
7.0

I am the professional called in when an entire company (or department) comes to a standstill due to an error or bug in a spreadsheet containing complex formulas and macros; fixing or enhancing code written by another developer is my specialty. 1. Examples of relevant Excel/VBA projects you have worked on. Please visit my profile here on Freelancer. 2. Details regarding your experience taking over existing or legacy VBA applications. When legacy code brings an entire department to a halt, I am the one called in to fix it (I have been doing this for decades!). 3. Your experience resolving complex VBA errors. This is what I have been doing most in Excel for decades (as well as in Access, Word, Outlook, and PowerPoint). 4. Your hourly and/or daily rate. Just €12.00 per hour or €99.00 per day. 5. Your availability for ongoing, on-demand work. I am fully available if we start immediately. 6. Your location/time zone. I am based in Brazil; my time zone is 4 hours behind yours (GMT -3). 7. Any relevant qualifications or certifications. Mathematics with Computing, Computer Science, Registered Accountant.
€12 EUR in 40 days
6.6
6.6

Hi, I am an Excel VBA and macro developer with 8 years of rich experience in Visual Basic, Excel, SQL, debugging, troubleshooting, and Microsoft 365. I can review your inherited workbook, understand its VBA structure, UserForms, formulas, external links, dependencies, and automated processes, then identify fragile areas and compatibility issues without rebuilding what already works. I will document the code, improve reliability, and support future fixes, maintenance, and feature development. I'm an individual freelancer and can work on any time zone you want. Please contact me with the best time for you to have a quick chat. I am comfortable signing an NDA and supporting ongoing Excel VBA work. Looking forward to discussing more details. Thanks. Emile.
€15 EUR in 40 days
5.9
5.9

Hi, I can take over your existing Excel/VBA application, understand how it works, and provide reliable ongoing maintenance without disrupting your current business process. I can review the VBA structure, dependencies, UserForms, formulas, external links, and compatibility with current Microsoft 365, while identifying fragile areas and existing errors. Rather than rebuilding unnecessarily, I’ll first understand the existing system and then make structured improvements focused on stability, performance, and maintainability. I can troubleshoot complex VBA issues, modify existing macros, develop new functionality, and document the code so future maintenance is easier. I’m available for the initial workbook assessment and would be interested in building a long-term support relationship if the first project is successful.
€15 EUR in 40 days
6.1
6.1

Hi! I am an experienced Excel VBA developer with 14 years of dedicated expertise taking over, debugging, and maintaining legacy macro-enabled workbooks. I specialize in auditing third-party code, resolving runtime errors, and checking Microsoft 365 compatibility without disrupting existing business logic. I can systematically assess your workbook's architecture, clear out fragile dependencies, add clear inline documentation, and set up a reliable backup process for ongoing support. I am available immediately for the initial review stage at an hourly rate of $20/hour, based in India (IST, UTC+5:30) with flexible availability for ad-hoc ongoing maintenance. I focus on stabilizing existing tools first rather than pushing for unnecessary rewrites, making sure your essential workflow stays smooth and reliable. Best Regards, Virendra
€16 EUR in 40 days
6.2
6.2

Hi there, I went through your project description and understand you need an Excel VBA specialist who will take ownership of an existing macro-enabled workbook, understand its architecture, resolve issues safely, and provide ongoing development without disrupting established processes. I’ll begin by reviewing the VBA modules, UserForms, workbook events, formulas, named ranges, external links, references, add-ins, and dependencies. Using the VBA editor, debugging tools, Excel/Microsoft 365 compatibility checks, and controlled test copies, I’ll trace existing errors and identify fragile areas before recommending changes. Where useful, Power Query, SQL, Access, or ODBC connections will be reviewed as part of the wider architecture. The initial assessment will produce documented findings, maintainability recommendations, and a practical backup/version-control approach. Future changes will be developed incrementally with regression testing to protect existing functionality. To scope your project clearly, I would like to ask whether the initial review will include the full production workbook and its external files, add-ins, and database connections? A project blueprint will be shared within 24–48 hours of award. Let’s review the workbook and establish a reliable long-term maintenance process. Kind Regards, Imran Ali
€12 EUR in 40 days
5.6
5.6

I got you! I can take over your existing macro-enabled Excel workbook, review the VBA structure, dependencies, UserForms, links, references, and provide a clear maintainability and risk assessment before making changes. I’m ready to handle the initial review plus ongoing support, debugging, documentation, and feature development. I’m young, a fast learner, available 24/7, and comfortable working carefully with legacy VBA without disrupting business-critical processes. Get the demo first before you pay. A couple of quick questions: does the workbook rely on external files/databases/add-ins, and are users currently on Windows Excel only or mixed with Mac/365 environments? Also, are there any recurring errors or slow processes you already know about? My rate and schedule are flexible for ongoing ad-hoc support, and I can align with your time zone as needed. Let’s chat and discuss the answers so I can plan the first review properly. Kind regards, Haroon Z
€18 EUR in 1 day
5.3
5.3

Hello, I can help you with the maintenance and improvement of an existing macro-enabled workbook. I am a VBA Developer with extensive experience in task automation in Excel. I have successfully taken over numerous legacy applications involving intricate formulas, VBA programs and macros in my career. This experience allows me to quickly identify areas for improvement, troubleshoot errors meticulously and bring new functionality with minimum disruption – exactly what your project calls for. Please feel free to reach out for any additional details. Thanks a lot. Best regards, Emilia
€15 EUR in 20 days
5.5
5.5

SolutionzHere has maintained 30+ legacy Excel/VBA workbooks for SMEs, taking over complex macros, UserForms, and data integrations. We'll review your code, troubleshoot errors, document dependencies, and advise on version control. Rate: €25/hr (mid-range). Availability: 20+ hrs/week, CET overlap. Quick question: Can you share the workbook (or a sanitized copy) for initial assessment?
€25 EUR in 40 days
5.5
5.5

Excel, VBA professional developer, ready to do the required. Sample reference works and reviews in links below. Regards https://www.freelancer.com/projects/excel/Excel-Auto-Execute-Macro-Upon/reviews https://www.freelancer.com/projects/excel/Fix-excel-VBA-36198376/reviews https://www.freelancer.com/projects/data-processing/data-processing-use-mail-merge/reviews
€12 EUR in 40 days
5.5
5.5

Warm greetings! I specialize in Excel VBA, macro development, debugging, and taking over legacy workbooks developed by other developers. Our team of 62 professionals has 9+ years of experience across Excel, VBA, SQL, Microsoft Access, data processing, and business automation. Here’s how we can help: • Audit the existing VBA code, modules, UserForms, references, named ranges, links, and dependencies • Troubleshoot errors and identify fragile areas without disrupting existing functionality • Test compatibility with current Excel/Microsoft 365 and improve reliability and performance • Document the system, recommend backup/version control, and implement approved enhancements We understand this is an inherited business-critical application, so our approach is to first understand how it works before recommending changes—not automatically rebuild it. We’re comfortable working under NDA and can provide ongoing ad-hoc maintenance and development support. Could you share the workbook size/complexity and whether the initial review will be performed on a copy of the production file? Also, are there any known VBA errors or failing processes you want us to prioritize?
€15 EUR in 40 days
5.4
5.4

Hi there, I am a seasoned developer in Excel VBA/Macro and have a high level of expertise in debugging, maintaining and upgrading existing Excel spreadsheets. I will be able to review your workbook thoroughly and fix any issues, ensure that your existing code works with Microsoft 365 without any glitches. I can also work on providing long-term support, maintenance, troubleshooting and new development of VBA as per your needs. Please let me know if you would like to see some examples of my projects and discuss about my availability and pricing. Cheers, Habib
€15 EUR in 40 days
5.1
5.1

I’ve inherited and maintained complex Excel VBA workbooks before, so this is right in my wheelhouse. I’ll review the code, document it, fix errors, and set up version control—then iterate on improvements without breaking existing functionality. I’ll check dependencies, UserForms, and Excel/365 compatibility, and provide structured recommendations. I’ll start immediately. Thanks, Andrii.
€15 EUR in 40 days
4.8
4.8

Kindly open a chat with me, so that I can send additional information to strengthen my bid. _____________________________________ Hi from South Africa! I read your project description with great interest. I am an experienced software developer and specialize in creating custom Microsoft Access database systems for small to medium sized businesses, and have worked with clients from a wide range of fields and applications. I normally become involved when clients have outgrown their Excel-based or legacy systems, and need something more sophisticated to manage their data. Many of my previous projects entailed taking over from other developers - either SQL, AirTable, Access or Excel-based systems - and making things work again, normally in a new Microsoft Access jacket, although I am also very comfortable working in Excel. If I do come across something that lies outside of my experience, I work with a close associate who is an Excel/VB expert who helps me out. I enjoy building long-term relationships with my clients, and making ongoing contributions and enhancements to the business, developing a deep understanding of their operation in the process. My systems normally run on a network (with SQL or Access as a database) or online, using MySQL as a database. In the case of SQL and MySQL, I connect via ODBC connectors - also when integration with an accounting system or other external systems is required. Kind regards - Carolina (Karin)
€15 EUR in 40 days
4.6
4.6

Hi, I’m an experienced Excel VBA / Macro Developer with 15+ years of experience in Excel automation, VBA development, debugging, and maintaining business-critical workbooks. I understand you need someone who can take over an existing Excel VBA application, understand how it works, and enhance it without disrupting existing functionality. This is exactly the type of work I’m comfortable with. What I can help with: Review and understand existing VBA code, modules, UserForms, and dependencies. Troubleshoot complex macro errors and identify root causes. Maintain and enhance legacy Excel applications developed by other developers. Add new features and improve performance and reliability. Review formulas, named ranges, external links, and Excel compatibility. Provide clear documentation and recommendations for backup/version control. Relevant experience: I have worked on Excel VBA automation, reporting solutions, business process automation, and database-related Excel applications. I also have experience with Power Query, Microsoft Access, SQL, and Power BI, which can be valuable when Excel solutions interact with other systems. Availability: Available for ongoing/ad-hoc support. Time zone: IST (UTC+5:30). Rate: Open to discussing a suitable hourly or daily rate based on the project requirements. I would be happy to start with the initial workbook assessment and build a long-term working relationship. Please share the workbook details, and let’s discuss how I can help.
€12 EUR in 40 days
4.9
4.9

Hello, I have strong experience in Excel automation using VBA, advanced formulas, and C# integration. I believe I am a good fit for this task because of: - Strong technical background in Excel VBA, advanced formulas, and C# automation. - Experience improving speed, performance, and stability in Excel systems handling huge datasets or involving many files. - Proven ability to take over existing VBA projects, understand complex or undocumented logic, and continue development smoothly without breaking existing functionality. - Ability to extend automation when needed, including: > Web data extraction into Excel > Integration with external databases or file-based systems > Advanced data analysis, including modern statistics or machine learning-based approaches - Well-organized and neat results (both the spreadsheet and the code). My rate is Eur 60/day (8 hours) Sample work can be provided when contacted. Please share the detailed requirements, and I can start immediately. Kind Regards, Freddy Ho
€12 EUR in 40 days
4.6
4.6

Your requirement is a strong match for experienced Excel VBA development and legacy application support. I can carefully take ownership of the existing macro-enabled workbook, first documenting its architecture, dependencies, UserForms, external links, references, and automated workflows before making changes. My approach would include reviewing and testing the current VBA structure, identifying fragile or incompatible areas, reproducing and resolving errors, checking Microsoft 365 compatibility, and documenting the code and operational dependencies. I would preserve existing functionality rather than recommending an unnecessary rebuild, while proposing practical improvements to reliability, maintainability, performance, and backup/version control. I am also well suited to ongoing ad-hoc support, including enhancements, new macros, troubleshooting, integrations, and updates arising from Excel changes. I can provide a structured initial assessment followed by clear recommendations and prioritized development work. Relevant experience, availability, rates, time zone, and project examples can be supplied with the application.
€17 EUR in 44 days
4.1
4.1

Hello, As a result of reviewing your requirements, I understand you need someone to take ownership of an existing VBA application—not rebuild a working business process unnecessarily. I have experience with Excel VBA, macro development, debugging, legacy code analysis, formulas, named ranges, UserForms, and SQL/data integrations. In my opinion, the first priority should be understanding the workbook before modifying it. I would map the VBA modules and execution flow, inspect references, external links/add-ins and file dependencies, identify fragile code, and test compatibility with current Excel/Microsoft 365. For troubleshooting, I trace errors through event handlers, module dependencies, object references and data flows rather than applying isolated fixes. I can then document the existing code, improve reliability/performance where appropriate, and establish a safe backup/versioning process before future changes. I’m also comfortable providing ongoing ad-hoc support for fixes, enhancements, new macros, and Microsoft 365 compatibility issues. My rate can fit within your advertised €12–18/hour range. Before starting, could you confirm the approximate workbook size and whether it currently uses external databases, add-ins, or network files? Best regards, Carlos.
€12 EUR in 40 days
4.3
4.3

Hi, I understand you need a developer who can take ownership of an existing Excel VBA application, understand how it works before changing it, and provide reliable ongoing maintenance and development without unnecessarily rebuilding the workbook. I can review the existing VBA modules, macros, UserForms, workbook structure, named ranges, formulas, external references, add-ins and other dependencies. I’ll trace the current workflows, identify fragile areas and compatibility issues with current Microsoft 365/Excel versions, then document the findings and recommended improvements. For ongoing work, I can troubleshoot VBA errors, modify existing functionality, develop new macros and improve performance while keeping existing business processes stable. Where relevant, I can also work with Excel/Access, SQL, ODBC connections and Power Query as part of the wider workflow. I’ll approach the initial review as a controlled assessment, making backups before structural changes and documenting modifications so future maintenance is easier. I can also recommend a practical version-control and backup process suited to an Excel/VBA application. I work from Morocco (UTC+1) and can coordinate through your preferred communication channel for ongoing support. Best regards, Houssame
€12 EUR in 39 days
4.4
4.4

Cork, Ireland
Payment method verified
Member since Nov 16, 2022
€250-750 EUR
min $50 USD / hour
£10-15 GBP / hour
€20-25 EUR / hour
₹12500-37500 INR
₹1500-12500 INR
min $50 AUD / hour
$10-30 USD
$15-25 USD / hour
₹12500-37500 INR
$30-250 USD
$15-25 USD / hour
$250-750 USD
$750-1500 USD
$10-30 USD
₹600-1500 INR
$250-750 USD
min $100000 USD
$10-30 USD
£20-250 GBP
$10-99 AUD