Optimized VBA for Focused QR Scanning
Budget: €30 – €250 EUR
I am looking for an expert in VBA and Excel who can modify the existing VBA to display only the ticket IDs on an Excel sheet, eliminating the need for a double scan with the QR code scanner hardware. This streamlined view is expected to significantly enhance our ticketing operations and accuracy.
- Display Data: Expect the refined VBA to display the ticket ID only, excluding the ticket holder's name, purchase date, and ticket type.
- Ticket ID Composition: Our ticket IDs are randomly generated alphanumeric codes. Expertise in dealing with such IDs will be beneficial.
- QR Code Scanning: The scanner hardware we use can read both physical and digital QR codes. A candidate with understanding of QR code scanning across both platforms would be ideal.
Prior experience in similar projects and proficiency in handling QR code scanner hardware would be appreciated.
Details of a Scanned Qr code:
{"eventName":"TickPlug Summer Party Series Part Two","quantity":"1","ticketId":"ZP1EA7J31D","ticketNumber":"1 of 1","paymentDate":"7/13/2024","paymentTime":"8:03:57 AM"}
- Display Data: Expect the refined VBA to display the ticket ID only, excluding the ticket holder's name, purchase date, and ticket type.
- Ticket ID Composition: Our ticket IDs are randomly generated alphanumeric codes. Expertise in dealing with such IDs will be beneficial.
- QR Code Scanning: The scanner hardware we use can read both physical and digital QR codes. A candidate with understanding of QR code scanning across both platforms would be ideal.
Prior experience in similar projects and proficiency in handling QR code scanner hardware would be appreciated.
Details of a Scanned Qr code:
{"eventName":"TickPlug Summer Party Series Part Two","quantity":"1","ticketId":"ZP1EA7J31D","ticketNumber":"1 of 1","paymentDate":"7/13/2024","paymentTime":"8:03:57 AM"}