
Completed
Posted
Paid on delivery
I have a bespoke Excel workbook that already contains several macros. I now need one additional routine that calls the Deepl API directly from VBA, so I can generate translated content automatically whenever a user updates the file. The macro must sit inside the existing spreadsheet, respect the current module structure, and take an API-key stored in a hidden sheet or named range. All the details are explained inside the page 7 and 8 of the attached BRD. Scope of work • The code should loop through the specific columns or rows I define (the range will be passed as a parameter or read from a config table) and send each cell’s value to Deepl. • Returned text replaces or populates the adjacent target column, leaving formulas in untouched areas intact. • Connection handling, throttling, and simple error reporting are required so the workbook never crashes if the quota is reached or the internet is down. Acceptance criteria – One click (or worksheet event) triggers a full pass that populates all necessary translations. – No hard-coded credentials; I can swap the key easily. – Clean, well-commented VBA compatible with Office 365 and Excel 2016. Please deliver the updated .xlsm file or a .bas export plus short setup notes so I can drop it straight into production. The production .xlsm file is also attached. You need to be an experienced VBA coder, with knowledge on the best API methods, so that you are available for potential upgrade and maintainance of the code. The VBA code must be properly documented with notes inserted, to ensure future maintainance.
Project ID: 40418518
60 proposals
Remote project
Active 13 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Hi there, I understand you need a robust VBA routine that integrates the DeepL API directly into your existing workbook, respecting your current structure while remaining stable, configurable, and production-ready. My approach is to build a modular VBA procedure that reads the API key from a hidden sheet or named range, loops through your defined input range, and sends each value to DeepL via a properly structured HTTP request. The returned translations will populate the adjacent target cells without disturbing formulas or protected areas. I’ll implement connection handling, rate limiting, and error control so the macro gracefully handles API limits, network failures, or invalid responses without breaking the workbook. The routine can be triggered via a button or worksheet event, depending on your preference. The code will be clean, well-commented, and designed for maintainability, making it easy to update ranges, swap API keys, or extend functionality later. It will be fully compatible with Excel 2016 and Office 365. Deliverables include the updated .xlsm or a .bas module, along with short setup notes explaining configuration and usage. Before starting, could you confirm the target language(s) and whether translations should overwrite or always populate a separate column? I’m ready to implement this cleanly within your existing workbook. Warm Regards, Aneesa.
€100 EUR in 1 day
6.1
6.1
60 freelancers are bidding on average €135 EUR for this job

As an Excel expert with a strong command over VBA and Visual Basic, I understand the unique challenges posed by your project. My proficiency in working with Macros, Excel VBA and Power BI coupled with my familiarity surrounding API integrations make me the ideal fit for this job. Not only can I develop a clean, well-commented code that's compatible with Office 365 and Excel 2016, but I also appreciate the need for scalable solutions that are easily maintainable. Explore my impressive profile here: https://www.freelancer.pk/u/utrathore3 . Note: "Delivering success is our commitment. To achieve this, we carefully assess your project's scope, and then provide customized costs and timelines that meet your unique needs." Thanks and Best Regards, Usman Tariq Rathore Work-Nix Solutions
€30 EUR in 1 day
8.2
8.2

As an experienced data analyst, your project aligns perfectly with my skillset in Excel and my speciality in macros. With a deep understanding of VBA and its functions, I am confident in delivering the required code functionalities without any conflicts on the existing ones. In addition to this, I have an updated knowledge of the best API methods and can leverage this to ensure smooth internet connection handling, throttling, and error reporting to avoid workbook crashes. I promise you a clean and concise VBA code compatible with Office 365 and Excel 2016 as mentioned. The deep translation functionality will be triggered on your desired worksheet event, allowing you or your team to generate translations effortlessly with just a single click. To make sure you always have total control over your operations, I ensure no hard-coded credentials in the workbook, allowing easy switching of API keys if need be. I'll wrap up by assuring you that besides timely delivery of the updated .xlsm file or a .bas export plus setup notes for production use, my commitment extends to documenting the VBA code extensively. This is crucial for you so that future upgrades and maintenance can be carried out seamlessly. Let's get started on ensuring efficient translated content generation within your workbook!
€140 EUR in 1 day
7.6
7.6

Hi, You need a robust VBA routine that integrates Deepl API into your existing workbook while respecting its current structure and ensuring stable execution. I will review your modules and BRD, then build a clean macro that loops through defined ranges, sends text to Deepl, and writes translations to target columns without disturbing formulas or existing logic. I will implement secure API key handling (via hidden sheet or named range), add error handling, throttling, and connection checks to prevent crashes, and ensure one-click or event-based execution. You’ll receive fully documented VBA code (.bas or updated .xlsm) plus clear setup notes so it can be deployed and maintained بسهولة. Ready to start right away. Usman Bashir
€135 EUR in 3 days
6.7
6.7

I ALREADY MADE SIMILAR PROJECT LIKE THAT BEFORE. I can add a clean VBA routine that integrates with the Deepl API—looping through your defined ranges, handling errors/throttling, and populating translations without breaking existing formulas. Secure API key handling + fully documented, maintainable code. 10+ years Advanced Excel experience, Certified VBA Programmer, MBA.
€50 EUR in 1 day
6.5
6.5

Hi, To add a new routine that calls the Deepl API from your existing Excel workbook, I'll implement a VBA macro that respects your current module structure. This will include: - Looping through specified columns or rows to send values to Deepl. - Populating the adjacent target column with returned text while keeping formulas intact. - Implementing connection handling and error reporting to prevent crashes. - Ensuring the API key is easily swappable and well-documented. I'll follow a structured approach to ensure clean and maintainable code, compatible with Office 365 and Excel 2016. Ready to start once you provide the attached BRD and any additional details. Thanks!
€100 EUR in 1 day
6.2
6.2

Greetings! I can help you with the current requirements. Lets catch up and done. Thank you Shivam K.
€150 EUR in 2 days
5.2
5.2

Hi, I am an Excel VBA automation developer with 8 years of rich experience in software development, with a background in Excel VBA, Excel macros, Visual Basic, API integration, Office 365, Excel 2016, and Deepl API. I can add a clean VBA routine inside your existing .xlsm structure to read the API key from a hidden sheet or named range, loop through configured rows/columns, call Deepl, and populate the target cells without touching formulas. I’ll also include throttling, connection/error handling, comments, and short setup notes so the macro is easy to maintain. 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. Looking forward to discussing more details. Thanks. Emile.
€250 EUR in 7 days
5.3
5.3

Hi there,I am a Data Scientist is a professional responsible for extracting actionable insights and knowledge from large volumes of data Microsoft applications Development. I can write clean, Excel, Word, Access, PowerPoint, Power BI, Outlook and creating VBA macros. Excel: Advanced Array Formulas, Charts, Pivot Tables, Pivot Charts, Mail Merge, VBA Macros, Excel Macros, Capabilities, Spreadsheets. Email through Outlook and Gmail, Add-in, Customized Macros. My top priority is to provide a high quality of work, I am willing to fully devote my time and energy to improve the service offered, with timely, accurate and professional results, building trust and a long term relationship with customer is my main objective. https://www.freelancer.com/u/GdevDataSceince Choosing me for this project not only means benefiting from my extensive skills in Excel and data analysis but also entrusting your sales data with someone who values precision and confidentiality. Let's begin working together on this valuable project to deliver lasting results that will positively impact your business. Thanks Gdev
€30 EUR in 2 days
5.0
5.0

Hi, I went through your requirement, and this is very much in line with the kind of VBA and Excel automation work I regularly handle. I’ve worked on macro-heavy workbooks and API integrations before, so I understand how important it is to fit new code cleanly into an existing structure without breaking anything. I can build a VBA routine that connects directly to the DeepL API, reads the API key from a hidden sheet or named range (so no hardcoding), and processes only the ranges you define via parameters or a config table. The macro will loop through the required cells, send content for translation, and write the results into the adjacent column while keeping formulas and other areas untouched. I’ll also include proper error handling for cases like API limits, network issues, or invalid responses, along with basic throttling so the workbook runs smoothly without hitting rate limits. The code will be clean, well-structured, and fully commented, making it easy to maintain or extend later. You’ll get either the updated .xlsm file or a .bas module (whichever you prefer), along with quick setup notes so you can deploy it without hassle. Happy to review pages 7–8 of your BRD and align everything before starting. Best, Naresh
€200 EUR in 1 day
4.6
4.6

Hi, there, I'm Kris from McKinney, Texas. I've worked on similar projects before, and with over 15 years of experience as a senior full-stack and AI engineer, I'm fully qualified to delivery this properly. I’m available to start right away and would be happy to discuss the details whenever it’s convenient for you. I would love to connect in chat to discuss details. Talk soon, Kris Kramer
€30 EUR in 1 day
4.6
4.6

Hi there, I am A.R.M. MASUD, with a strong data science background. I specialize in creating customized Excel-based solutions that streamline business processes, enhance data management, and enable insightful analysis. Whether it’s developing advanced macros, automating workflows, or integrating Excel with other Microsoft applications, I deliver robust, efficient solutions tailored to your specific needs. My expertise includes AR/AP Management, Financial Statement Preparation, Expense Tracking, Budgeting and Forecasting, Cash Flow Management, and APR Calculation via the Sales Force Formula. I design and develop advanced Excel workbooks with tailored features such as formulas, macros, pivot tables, Power Query, mail merge, email via Outlook and Gmail, add-ins, customized macros, and automated repetitive tasks using Excel VBA. I also create interactive dashboards for real-time data visualization, providing fully functional and customized Excel workbooks, automated workflows, and macros for efficient task management and data integration between Excel and other business systems. https://www.freelancer.com.bd/projects/excel/Advanced-Data-Processing-Chart/reviews Thank you for considering your Microsoft Excel development project. I am confident that my expertise and commitment to excellence will add significant value to your business operations. Thanks A.R.M MASUD
€30 EUR in 1 day
4.2
4.2

As an experienced VBA coder and an expert in Office 365 and Excel 2016, I'll be the perfect fit for developing your deep translation macro. Your requirement of automating the process of calling the Deepl API to translate content whenever a user updates the file is something I have dealt with before. I recently helped a client with a similar project which involved creating a comprehensive range of automation macros within Excel. I integrated APIs for data import/export, SQL connectivity, and even web scraping tasks. Rest assured, the code delivered for your project will be clean, well-documented and compatible across different versions. One of the key strengths I bring to the table is my thorough understanding of not just VBA but also of APIs. Having worked on different projects involving API integration, I'm adept at designing efficient code that handles connection throttling, monitors quota limits and ensures the application never crashes due to internet issues. Moreover, my commitment to long-term support is evident through my emphasis on clean and well-commented code. Future maintenance will not be a hassle with logical comments inserted throughout the code that guide through flow and functionality. With my robust technical execution partnered with streamlined communication, you can expect results delivered fast without compromising quality. Let's get started on building a deep translation macro to streamline your workflow!
€140 EUR in 3 days
4.3
4.3

Hey , I just finished reading the job description and I see you are looking for someone experienced in Excel VBA, API Integration, VB.NET, Excel, API, Excel Macros and Visual Basic. This is something I can do. Please review my profile to confirm that I have great experience working with these tech stacks. While I have few questions: 1. These are all the requirements? If not, Please share more detailed requirements. 2. Do you currently have anything done for the job or it has to be done from scratch? 3. What is the timeline to get this done? Why Choose Me? 1. I have done more than 250 major projects. 2. I have not received a single bad feedback since the last 5-6 years. 3. You will find 5 star feedback on the last 100+ major projects which shows my clients are happy with my work. Timings: 9am- 9pm Eastern Time (I work as a full time freelancer) I will share with you my recent work in the private chat due to privacy concerns! Please start the chat to discuss it further. Regards, Abdul Haseeb Siddiqui
€30 EUR in 1 day
3.7
3.7

Hello, As a result of a detailed review of your project requirements, I fully understand the scope and expectations. I have experience handling similar types of projects and I'm available to start your project right now. I bring deep expertise in Excel VBA, Excel Macros, Visual Basic, API Integration, and Office automation with over 10 years of experience. One of the key challenges in this project is adding the DeepL API routine into the existing .xlsm without disturbing current macros, formulas, or module structure. I can build a clean VBA routine that reads the API key from a hidden sheet/named range, loops through configurable ranges, handles throttling/errors, and safely writes translations into target columns. I reviewed that the BRD details are on pages 7 and 8, so I would align the macro behavior exactly with those instructions and deliver either the updated workbook or a documented .bas export with setup notes. I have a couple of quick questions. • Should translation run by button click, worksheet change event, or both? • Do you want failed translations logged in a sheet for later review? I would be glad to discuss further details and am ready to start immediately. Looking forward to hearing from you. Best regards, Carlos.
€30 EUR in 5 days
3.7
3.7

Hi I can implement a clean and reliable VBA integration with the DeepL API directly inside your existing workbook, fully aligned with your current module structure and BRD. I will create a reusable VBA routine that reads your defined ranges or config table, sends each value to DeepL, and writes the translated result into the correct adjacent cells without affecting formulas. The API key will be securely read from a hidden sheet or named range, ensuring no hardcoded credentials. The solution will include proper request handling, batching or throttling to respect API limits, and robust error handling so the macro never breaks due to connectivity issues or quota limits. I will also structure the code for maintainability with clear comments, modular functions, and easy configuration for future updates. You will receive a ready to use .bas module or updated .xlsm file along with short setup instructions so you can deploy it immediately. I have strong experience with VBA automation and API integrations and can ensure this runs smoothly in both Office 365 and Excel 2016. Best, Justin
€1,000 EUR in 7 days
3.8
3.8

Hello, I have experience with Excel VBA and integrating APIs within custom workbooks, including automating data processing for financial models and enhancing reports with dynamic data updates. I could build a macro for Deepl API integration that loops through specified ranges, sending cell values for translation and updating adjacent cells with the returned content, all while adhering to your existing module structure. For efficient processing, implementing a configuration table for dynamic range definitions could streamline updates. Let's discuss!
€100 EUR in 3 days
3.7
3.7

Hi, I will implement a robust VBA routine inside your existing workbook that securely calls the DeepL API using an API key stored in a hidden sheet or named range, processes defined ranges dynamically, and writes translated results into target columns without affecting existing formulas. I will also include proper throttling, retry logic, and error handling so the workbook remains stable even under API limits or connectivity issues, along with clear documentation so future maintenance is straightforward. Best regards, Juan
€140 EUR in 1 day
3.9
3.9

Hi, The goal is to seamlessly integrate Deepl API into an existing Excel workbook to automate content translation upon user updates. The challenge lies in maintaining the current module structure and implementing error handling to prevent crashes. I propose a solution where the VBA code loops through specified columns/rows, sending cell values to Deepl and populating adjacent target columns with translated text. The code will include connection handling, throttling, and error reporting features for a smooth user experience. With my expertise in Excel VBA and API integration, I have successfully delivered similar automation solutions with measurable efficiency gains. My certification in engineering further validates my capabilities in this domain. I look forward to discussing further details and collaborating on this project. Please feel free to reach out via chat. My time zone is flexible, so I can easily work around yours. Cheer, Dax.M
€150 EUR in 1 day
3.5
3.5

Hello, I can develop and integrate a clean, well-documented VBA routine in your existing workbook to call the DeepL API and automate translations seamlessly. I have strong experience with Excel VBA + API integrations, including handling authentication, JSON parsing, and error-safe execution. I will: Add a macro that loops through configurable ranges (from parameters or a config table) Send each cell’s text to DeepL and populate the adjacent target column without disturbing formulas Store the API key securely in a hidden sheet or named range (no hardcoding) Implement connection handling, throttling, and error logging to prevent crashes (quota/network issues) Ensure compatibility with Excel 2016 and Office 365 Provide fully commented code and clear setup instructions You’ll receive either the updated .xlsm file or a .bas module, ready to plug into production, along with guidance for future maintenance or upgrades. Regards, Bakhtawar
€30 EUR in 1 day
3.2
3.2

I understand that my front-end development skills listed in my profile may make it seem like VBA Excel is not a direct fit for me, but I have dedicated a considerable amount of time and effort to constantly broadening my skill set. Specifically embracing the challenge of integrating different programming languages and systems. Excel VBA has been one of those systems. My backend service development correlates with your project's requirements: dealing with APIs, error handling, connectivity issues, and runtime-related challenges. This practical experience significantly aids in preventing the workbook from crashing or disrupting user experience when facing API quota or internet connection issues. Moreover, as a mobile and web developer who values clean code, I am well-versed in documentation techniques to ensure easy understanding and future maintenance of the programs I create. Given my adaptability, resilience in problem-solving, and commitment to quality output, I believe I'm an excellent candidate!
€30 EUR in 1 day
3.3
3.3

Le Touvet, France
Payment method verified
Member since Aug 30, 2021
€12-18 EUR / hour
€12-18 EUR / hour
€30-250 EUR
€30-250 EUR
€8-30 EUR
$8-15 USD / hour
$10-30 USD
$30-250 USD
₹600-1500 INR
₹600-1500 INR
₹600-1500 INR
min ₹2500 INR / hour
₹1500-12500 INR
€250-750 EUR
₹12500-37500 INR
₹600-601 INR
₹400-750 INR / hour
$80-240 HKD
₹100-400 INR / hour
$10-30 USD
$250-750 USD
₹600-1500 INR
$15-25 USD / hour
₹750-1250 INR / hour
₹100-400 INR / hour