Automated Excel Courier Tracker

@axiomswb

Your VRL-first courier tracker with GATI and Blue Dart plug-in slots is exactly the kind of project I have built before, so let me tell you specifically how I will handle it. For status scraping I will use Selenium Basic rather than the old IE object, because IE automation breaks silently on modern courier sites and you would never know a status was missed. Selenium Basic is free, runs inside VBA, and actually renders the JavaScript that VRL's tracking page depends on. For screenshots I will call the native Windows Snipping Tool via Shell, timed to fire after the page fully loads, saving each PNG to a folder named by today's date automatically. One problem you may not have considered: WhatsApp Web requires the phone to stay connected and sessions time out. I will build in a reconnect-wait loop that pauses and prompts you before continuing rather than failing silently mid-run. The courier URL table will sit in a named Config sheet — one row per carrier, exactly as you described — so adding a new courier means typing a URL into one cell, nothing else. I can deliver the fully commented .xlsm, helper setup steps for Selenium Basic, and the readme within three days. One question: on your Source sheet, is the courier name always exact text like VRL or GATI, or does it sometimes appear as part of a longer string such as VRL Logistics?

@Mokshith30

Hi, I can develop a single-click Excel VBA shipment monitoring solution that automates the complete workflow. I’ll build a modular courier-tracking structure starting with VRL, with GATI, Blue Dart, and future tracking URLs easy to add. The macro will update live shipment status and timestamps, capture and save tracking screenshots automatically, generate a Today/Tomorrow Summary sheet, and trigger WhatsApp Web messages with the LR number, supplier, status, and screenshot. I’ll provide a fully commented, password-free `.xlsm`, documented helper scripts/references if required, and a clear README explaining courier URLs, folder settings, and WhatsApp configuration. I have strong experience with Excel VBA, automation, web data extraction, and file handling, and will focus on reliability and a simple one-button user experience.

@mattafareed4848

Hello I can develop a single-click, fully commented Excel VBA solution covering courier tracking, timestamped screenshots, today/tomorrow summaries, and WA Web alerts, with a flexible structure for VRL, GATI, Blue Dart, and future carriers. Regards Muhammad

@ukokab

I will build a single‑click Excel macro (VBA) that reads LR numbers, supplier names, and couriers from your “Source” sheet, opens the courier website (structured for easy addition of new couriers like GATI, Blue Dart), captures live status and timestamp, and writes them back. It will take a full‑page screenshot of the tracking result, save it to a dated folder (PNG), and note the file path. It will generate a “Summary” sheet showing consignments due today/tomorrow. It will send a WhatsApp Web message to your dispatch group with LR number, supplier name, and the screenshot. Deliverables: .xlsm file with commented VBA, helper scripts, and a read‑me for editing courier URLs and WhatsApp group IDs. **Example Project:** https://www.freelancer.com/u/ukokab?review_context_id=40409504&review_type=project&frm=ukokab&sb=t https://www.freelancer.com/u/ukokab?review_context_id=40330501&review_type=project&frm=ukokab&sb=t Best, Usman K https://www.freelancer.com/u/ukokab

@omkumarsingh1

You’ve already defined the workflow clearly; the real challenge is making one-click execution dependable without turning the workbook into a fragile VBA script. I can build this as a modular .xlsm solution where each courier has its own tracking function, with VRL as the primary integration and GATI/Blue Dart ready to be added later. The macro will process new LRs, capture and timestamp live status, save dated screenshots with automatic file paths, build the Today/Tomorrow summary, and handle WhatsApp Web notifications with the required shipment details and screenshot. I’ll keep the VBA fully commented, password-free, and provide a simple README covering courier URLs, group IDs, folders, and maintenance. I’ll also test the output against the actual tracking pages for accuracy. Can you share a sample Source workbook?

@caajoys

I can turn this into a true one-click shipment monitoring system that eliminates repetitive tracking work and gives your dispatch team a complete, time-stamped audit trail. My focus will be on making the solution reliable today while keeping the courier structure flexible enough to add GATI, Blue Dart, or future carriers without rebuilding the entire macro. Thank you for considering my proposal. I have gone through the requirements in detail. I can build the .xlsm solution with commented VBA covering automated tracking, status/time capture, dated screenshot storage, path logging, daily/tomorrow shipment summaries, and WhatsApp Web alerts. I’ll structure the courier URLs separately so they are easy to update. I’ll also provide a clear README and document any helper components required. I have uploaded samples similar to this project completed by me earlier in my profile, including Excel automation, VBA macros, dashboards, and reporting solutions. I’ll test the complete workflow carefully to ensure existing data is preserved and each step runs correctly from a single button. I bring 10+ years of experience in Excel, VBA automation, reporting, and process improvement, along with Chartered Accountant (ICAI) and CPA qualifications. Share the workbook and I can review the flow and start building a robust, practical automation solution.

@Sahyadri96

@SahyadriTech #SahyadriTech Completed Projects: 1. Hotel Booking Management & Tracking System (Excel + VBA Script) 2. Appsheet: ERP system for textile business 3. MNGL Gas Incident Tracker & Dashboard (Google Sheets + Google Data Studio) 4. Daily Expenses Tracker (Google Sheets) 5. Option Scalping Strategy Automation (Excel VBA) 6. Nifty50 Live Option Chain Dashboard (Google Sheets) 7. Binary Trading Sheet (Google Sheets) 8. Customer Data Cleaning & Sorting Tool (Excel VBA & Python) 9. Historical Stock Closing Price Analysis for 2,600 Stocks (Excel & Python) 10. Power Bi dashboard for F1 Car racing insights 11. GOLD Loan tracking in Google sheet and Google Data studio 12. Local Taxi Tracking System (Google Sheets + Google Data Studio) 13. Appsheet Milk Drivers wages and attendance system (Appsheet + Google sheet ) Key Highlights: 1. Pay only if satisfied with the work 2. Expert in Power BI, Excel, VBA Macros, Google Sheets, Google Apps Script, and Python 3. Experience in 3 American MNCs 4. Skilled in Data Analytics, Automation, and Visualization 5. Proficient in Statistical Analysis 6. Offer Long-Term Support for all projects 7. Quick Delivery with multiple revisions I can deliver any project related to Data Analytics, Automation, and Reporting with precision and reliability.

@vashishtrupinder

I have 8+ years of experience in web development and am familiar with modern web technologies, frameworks like Excel VBA and other tools. I have worked on similar project already here is example : You need one button that runs the whole shipment tracking flow. I’ll write clean VBA code that reads every LR number from the Source sheet, opens the proper courier site, pulls the live status text, and writes it back with a time-stamp. It will capture a full-page screenshot, save it to a dated folder, and record the file path. The macro will build a Summary sheet for today’s and tomorrow’s arrivals, then send WhatsApp Web messages with the LR number, supplier, and screenshot. Courier URLs and WhatsApp group IDs will be easy to edit, and every line of code will be commented. I can start right away.

@EricLeroyDev

Hello, Your setup is clear: an LR list where VRL leads today but GATI and Blue Dart need to slot in later, all fired from one button. Before shaping anything, two points usually decide how reliable this stays day to day. When you paste an LR on the VRL, GATI or Blue Dart pages, do they show the status straight away, or do they sometimes ask for a login or a CAPTCHA? And is the PC running the macro kept permanently signed in to WhatsApp Web on the dispatch group? One thought: rather than forcing every step through pure VBA, would you be open to Excel staying the control panel while the tracking, screenshots and WhatsApp run through a lighter engine behind it? It tends to survive site updates far better. On budget, expect to land within yours; I will confirm a firm figure once these answers are in. Happy to talk it through whenever suits you. Best regards, Eric

@Yogaselvan07

Hi, I read the full flow and can build all four steps: read the LR numbers, scrape live status from each courier site, timestamp it back into the row, save a screenshot to a dated folder, build the today/tomorrow Summary sheet, and send the WhatsApp alert per shipment. How I'd build it cleanly: one button in Excel that calls a small Python helper (free, no paid licences). Plain VBA struggles to scrape modern courier sites and capture full-page screenshots reliably, so the button triggers Python (Selenium) for the scraping, screenshots and WhatsApp, then writes everything back to the sheet. Courier URLs sit in one config, so you add GATI, Blue Dart or any new carrier by editing one line. To de-risk it: I'll build VRL end-to-end first as a working sample, so you press the button once and see the status, screenshot, summary and a WhatsApp message go out, before I add the rest. One question: for the WhatsApp step, should the helper drive your logged-in WhatsApp Web session, or do you have a WhatsApp Business API number? That decides how I make the alerts reliable. Yogaselvan

@michela542

Hi, I’ve built Excel automation workflows involving structured data processing, external integrations, automated reporting, file generation, and API/browser-based workflows. The most important part of your project is making the entire shipment-monitoring process reliable with one click while keeping each courier integration easy to extend. ✅ One challenge is supporting different courier websites without hardcoding the entire workflow around VRL. I’d structure the VBA solution around configurable carrier modules, where each courier has its own tracking URL and extraction logic, making GATI, Blue Dart, or future carriers easier to add. ✅ Another challenge is collecting live status data and screenshots reliably. Where courier sites permit automation, I’d use a lightweight helper such as Python/Playwright alongside Excel VBA rather than fragile screen-coordinate automation. The macro would trigger the process, update status/timestamps, save dated PNG screenshots, and write file paths back into Excel. I can deliver a commented .xlsm workbook, helper scripts, configurable courier settings, automatic Summary generation for today/tomorrow deliveries, and a clear README explaining maintenance and setup. Best regards, Michel

@Lenard007

Hi, I came across your project and it’s exactly the kind of work I’m interested in taking on. I can help you build a clean, professional, and user-friendly Excel macro that handles your automated courier tracking seamlessly. My approach ensures that the macro operates efficiently, allowing you to easily plug in new courier URLs as needed. I’ve successfully completed similar projects that involved VBA coding and automation, and I focus on delivering high-quality solutions with full documentation for ease of use. I’d be happy to discuss your project and ideas with you. Feel free to message me and we can take it from there. Regards, Lenard007

@ridwaan6254

Points one to three are straightforward VBA: read the new LR numbers off Source, hit the carrier, write the live status and a timestamp back into the same row, save a dated PNG and note the path beside the status, then build the Summary sheet for everything due today and tomorrow. Structuring the carrier as a pluggable URL plus a small parser per courier is the right instinct, and that is how I would build it, so GATI and Blue Dart drop in later without touching the rest. Two honest warnings before you pick anyone. Point four is the problem. Automating WhatsApp Web is against WhatsApp terms, their session changes without notice, and it can get your dispatch number banned. Anything that works today stops working, usually in the middle of a week you need it. I would build that part the way that keeps your number safe: either the WhatsApp Business API if you want it truly hands-off, or a one-click send that opens the message pre-filled with the LR number, supplier and status with the screenshot attached. Same outcome, no ban risk. Tell me which you prefer and I will build that one. Second, courier sites change their markup, so a tracker is never finished. I comment the parsing for each carrier plainly, so when VRL moves a field you or anyone else can fix that one line instead of paying for a rewrite. You get the .xlsm with fully commented VBA and no passwords. Ridwaan M

@SomeeLee25

Hello, With my background in Excel automation, Python data processing, AWS EC2 deployment, and journalism experience for clear documentation, I can deliver a robust, easy-to-use solution that keeps your dispatch team updated in real time. I can build a single-click Excel macro that automates your courier tracking workflow end-to-end. Deliverables: • Automated status capture from courier websites (VRL, GATI, Blue Dart, extendable) • Full-page screenshots saved to dated folders with file paths recorded in Excel • Summary sheet showing consignments due today and tomorrow • WhatsApp Web alerts with LR number, supplier, and status screenshot • Fully commented VBA code, helper scripts, and a clear read-me for editing URLs and group IDs Timeline: 2 weeks Looking forward to working on your project. Best regards, Somee