阅读说明：本技术 一种基于宏的数据录入方法 (Data entry method based on macro ) 是由 闫冬 韩晓 李斌 张涛 于 2020-07-27 设计创作，主要内容包括：本发明涉及一种基于宏的数据录入方法,解决了现有技术中无纸化办公中,人工操作录入数据效率低,任务繁重的问题。一种基于宏的数据录入方法,步骤如下：(1)设置宏对任意Word文档的应用：打开宏文件,通过管理器对代码进行修改,使得宏方案代码位于Normal模块下；(2)设置Word文档样式：提取宏,并更改设置页面边距。本发明通过特定代码的宏文件代码应用到共用模板中,通过将宏文件与新建的文档设置在同一文件夹中,通过在新文件夹中直接点击生成总目录的宏或者生成参考文献的宏,即可实现数据的一键录入,实现了宏在Word文档中的应用,提高提取文档或者文献的效率,降低了工作人员数据录入的工作量,大大提高了工作人员的工作效率。(The invention relates to a macro-based data entry method, which solves the problems of low efficiency and heavy task of manual data entry in paperless office in the prior art. A macro-based data entry method comprises the following steps: (1) setting up the application of macros to any Word document: opening the macro file, and modifying the code through the manager to enable the macro scheme code to be located under a Normal module; (2) setting a Word document style: and extracting macros and changing the set page margin. According to the invention, the macro file code of the specific code is applied to the common template, the macro file and the newly-built document are arranged in the same folder, and the macro for generating the general directory or the macro for generating the reference document is directly clicked in the new folder, so that the data can be input by one key, the macro is applied to the Word document, the efficiency of extracting the document or the document is improved, the workload of data input of a worker is reduced, and the working efficiency of the worker is greatly improved.)

1. A macro-based data entry method is characterized by comprising the following steps:

(1) setting up the application of macros to any Word document: opening the macro file, and modifying the code through the manager to enable the macro scheme code to be located under a Normal module;

(2) setting a Word document style: extracting macros, and changing and setting page margin, line spacing, document picture size format, document style, font and font size;

(3) generating a total document: (3.1) placing the files to be extracted in the same folder, creating a new Word document for extracting the total directory, opening the new document, and selecting a macro for generating the total directory; (3.2) if the file to be extracted is a reference, the page number of the total directory after extraction is generated according to the page number in each document, and the page number ordering of the newly-built document is not carried out.

2. A macro based data entry method according to claim 1, wherein in step (1) Alt + F11 is clicked to confirm whether the code location is under Normal module.

3. A macro based data entry method according to claim 1, wherein the step (2) of setting page margins is performed only once, and the document picture size format setting is for the whole document picture and the document style setting is for the whole document style.

4. A macro-based data entry method according to claim 1, wherein when the total catalog is generated in step (3), the naming sequence number of the new document needs to be a continuous sequence number, when the macro for extracting the reference document is used for the new document, other documents need to be kept closed, only the document category containing the naming number is extracted, the document is not successfully extracted, and the position of the document which is not successfully extracted is automatically prompted when the document is generated.

Technical Field

The invention relates to a macro-based data entry method.

Background

The data entry means that the encoded data and actual numbers are recorded on a storage medium through an entry device for calling when the electronic computer is operated.

The data entry can be divided into questionnaire entry, digital entry, archive entry and Word documents, Excel data sheet, WPS document, pure English entry, pure digital entry, Chinese and English mixed data entry, and entry of webpage HTML file format and PDF format files.

Most of the existing digital input methods are traditional manual input methods, but with the development of paperless office work, data input becomes a heavy task, and the working efficiency of workers is greatly increased;

therefore, a macro-based data entry method is proposed, which enables a macro to be applied to a Word document by modifying macro code setting, so as to improve the efficiency of extracting the document or literature and further improve the working efficiency of workers.

Disclosure of Invention

The invention aims to provide a macro-based data entry method, which solves the problems of low efficiency and heavy task of manual data entry in paperless office in the prior art.

In order to achieve the purpose, the invention adopts the following technical scheme:

a macro-based data entry method comprises the following steps:

(1) setting up the application of macros to any Word document: opening the macro file, and modifying the code through the manager to enable the macro scheme code to be located under a Normal module;

(2) setting a Word document style: extracting macros, and changing and setting page margin, line spacing, document picture size format, document style, font and font size;

(3) generating a total document: (3.1) placing the files to be extracted in the same folder, creating a new Word document for extracting the total directory, opening the new document, and selecting a macro for generating the total directory; (3.2) if the file to be extracted is a reference, the page number of the total directory after extraction is generated according to the page number in each document, and the page number ordering of the newly-built document is not carried out.

Preferably, in step (1), click Alt + F11 to confirm whether the code position is under the Normal module.

Preferably, the setting of the page margin in the step (2) is performed only once, the document picture size format setting is specific to the whole document picture, and the document style setting is specific to the whole document style.

Preferably, when the total directory is generated in the step (3), the new document naming sequence number needs to be a continuous sequence number, when the macro for extracting the reference document is used for the new document, other documents need to be kept closed, only the document category containing the book name number is extracted, the document which is not successfully extracted is extracted, and the position of the document which is not successfully extracted is automatically prompted when the document is generated.

The invention has at least the following beneficial effects:

1. the macro file code of the specific code is applied to the common template, the macro file and the newly-built document are arranged in the same folder, and the macro for generating the total catalog or the macro for generating the reference document is directly clicked in the new folder, so that the data can be input by one key, the macro is applied to the Word document, the document or document extracting efficiency is improved, the data input workload of a worker is reduced, and the working efficiency of the worker is greatly improved.

Drawings

In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings needed to be used in the description of the embodiments are briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.

FIG. 1 is a macro code modification screenshot;

FIG. 2 is a macro code view screenshot;

FIG. 3 is a generating total catalog screenshot.

Detailed Description

In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.