Version 1
: Received: 21 February 2023 / Approved: 23 February 2023 / Online: 23 February 2023 (02:23:30 CET)
How to cite:
Torcãtoru, C.; Sãvescu, D. Efficiency in B2B Communications: The Benefits of VBA Macro Implementation for Repetitive Tasks. Preprints2023, 2023020394. https://doi.org/10.20944/preprints202302.0394.v1
Torcãtoru, C.; Sãvescu, D. Efficiency in B2B Communications: The Benefits of VBA Macro Implementation for Repetitive Tasks. Preprints 2023, 2023020394. https://doi.org/10.20944/preprints202302.0394.v1
Torcãtoru, C.; Sãvescu, D. Efficiency in B2B Communications: The Benefits of VBA Macro Implementation for Repetitive Tasks. Preprints2023, 2023020394. https://doi.org/10.20944/preprints202302.0394.v1
APA Style
Torcãtoru, C., & Sãvescu, D. (2023). Efficiency in B2B Communications: The Benefits of VBA Macro Implementation for Repetitive Tasks. Preprints. https://doi.org/10.20944/preprints202302.0394.v1
Chicago/Turabian Style
Torcãtoru, C. and Dan Sãvescu. 2023 "Efficiency in B2B Communications: The Benefits of VBA Macro Implementation for Repetitive Tasks" Preprints. https://doi.org/10.20944/preprints202302.0394.v1
Abstract
The best business relationships are built as relationships between people and organizations that work together to achieve common goals. In the current digital era, B2B collaboration relationships are essential for business success. The response time to customer requests can be a key factor in maintaining these relationships and obtaining a competitive advantage. The use of VBA automation for repetitive tasks can help speed up this process, but it is important that computer operators have medium knowledge about using VBA macros. This work deals with issues related to improving response times to requests received by email, using a macro program for repetitive tasks. The empirical study was conducted on an average of 50 daily emails for order confirmation, with an average writing time of 68 s per email, resulting in a potential reduction in working time for the operator of approximately 1 h/day, only for order confirmation. The results show a significant improvement in working time for computer operators, using VBA buttons for repetitive tasks.
Keywords
business relationships; B2B collaboration; time management; VBA automation; macro programming; job satisfaction; performance; sustainable human resources management
Subject
Computer Science and Mathematics, Information Systems
Copyright:
This is an open access article distributed under the Creative Commons Attribution License which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.