Preprint Article Version 1 Preserved in Portico This version is not peer-reviewed

Efficiency in B2B Communications: The Benefits of VBA Macro Implementation for Repetitive Tasks

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. 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. Preprints 2023, 2023020394. 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

Comments (0)

We encourage comments and feedback from a broad range of readers. See criteria for comments and our Diversity statement.

Leave a public comment
Send a private comment to the author(s)
* All users must log in before leaving a comment
Views 0
Downloads 0
Comments 0
Metrics 0


×
Alerts
Notify me about updates to this article or when a peer-reviewed version is published.
We use cookies on our website to ensure you get the best experience.
Read more about our cookies here.