Records Management System Journal
Vol. 2 No. 1 (2023): Vol. 2 No.1 Tahun 2023

MAKING APPLICATIONS FOR ARCHIVING INCOMING AND OUTGOING LETTERS AT PT FELIXINDO JAYA PERKASA BASE ON VBA EXCEL

Rizki Mario Armando Saragih (Politeknik Negeri Bandung)
Mohammad Rizal Gaffar (Unknown)



Article Info

Publish Date
16 Oct 2023

Abstract

Information regarding incoming and outgoing mail is very important for companies to make decisions on the work being carried out, mistakes often occur when searching for archival data because the filing system is not detailed and irregular, therefore changes need to be made to the filing system so that it can manage data and information according to company needs. PT Felixindo Jaya Perkasa has an electronic filing system in the form of a sheet in Microsoft Excel, but the electronic archive does not include complete information so that the process of searching for archival data is not effective and efficient. Changes to the filing system are made with consideration of the effectiveness and efficiency of using the system, Visual Basic Application/VBA in Microsoft Excel can be used as a basis for making new filing system applications. VBA works with the Microsoft Excel program language which is then compiled into a company filing system application, the application is used to input incoming and outgoing mail data, and search for and delete data on company system applications so that the use of the filing system can be more effective and efficient.

Copyrights © 2023






Journal Info

Abbrev

rmsj

Publisher

Subject

Economics, Econometrics & Finance

Description

Records Management System Journal is one of the scientific journal published by Commerce Department, Bandung State of Polytechnic collaborating with Ebiz Prima Nusa. The objectives of RMSJ is to share knowledge and application about records system, information management, knowledge management, and ...