Excel Mileage Tracking Tool with VBA

Замовник: AI | Опубліковано: 10.10.2025

I need a professional Excel/VBA mileage tracking tool that calculates driving distances between two addresses using the Bing Maps API. The system should automatically compute reimbursement amounts based on a fixed rate (€0.30/km by default). Here are the key features: - Fetch driving distances (km) between Start and Destination addresses. - Calculate total reimbursement amounts (distance × €0.30), with options for one-way or round trip (×2). - Include a configuration sheet for setting the API key and adjusting the rate. - Provide buttons for “Calculate All” and “Clear” actions, along with clear status messages (e.g., OK, Error, Not Found). - Avoid reliance on external Add-ins. The solution must use the Bing Maps REST API (with optional fallback to Google Maps or OpenStreetMap), work locally in Excel (Windows, Office 365), and feature properly commented VBA code with robust error handling. Deliverables: - A functional Excel file (.xlsm) with working macros. - A separate VBA module for API integration logic. - A short user guide included in the file. I’m looking for someone experienced in VBA who can deliver the solution ASAP. Please emphasize your relevant VBA experience in your application.