Office automation VBA

Office automation refers to the various computer machines and software used to create, collect, store, manipulate and digitally relay the office information necessary for the performance of basic tasks. The storage of raw data, the electronic transfer and the management of electronic business information constitute the basic activities of an office automation system. [1] Office automation makes it possible to optimize or automate existing office procedures.

The backbone of office automation is a LAN, which allows users to transfer data, mail and even voice across the network. All office functions, including dictation, typing, filing, copying, faxing, telex, microfilm and recording management, telephone and switchboards, fall into this category. Office automation was a popular term in the 1970s and 1980s when the desktop computer exploded onto the scene.

Advantages are:

Office automation makes it possible to accomplish many tasks more quickly.

It eliminates the need for a large staff.

Less storage is needed to store the data.

Several people can update the data simultaneously in the event of a schedule change.