All the things you want to do at the same time can be done by the macro at one time, and all the commands to be repeated (such as speaking or other actions) can be defined in the macro in advance.
1. What is a macro?
Macro is a special function designed by Microsoft for its OFFICE software package, which aims to automate some tasks in user documents. Both WORD and EXEAL in OFFICE have macros. In the following discussion, we take WORD as an example.
If you repeat a task in Word, you can use a macro to automate it. Macro combines a series of Word commands and instructions into one command to realize the automation of task execution. You can create and execute macros instead of manually performing a series of time-consuming and repetitive Word operations.
The following are some typical applications of macros:
Accelerate daily editing and formatting.
Combine multiple commands
Make the options in the dialog box easier to access.
Automate a series of complex tasks.
Word provides two ways to create macros: macro recorder and Visual Basic editor.
The macro recorder can help you start creating macros. In Visual Basic for Applications programming language, Word records macros as a series of Word commands.
You can open the recorded macro in the Visual Basic editor and modify its instructions. You can also use the Visual Basic editor to create very flexible and powerful macros, including Visual Basic instructions.
You can save a macro to a template or document. By default, Word stores macros in a common template so that all Word documents can be used. Note that almost all macro viruses use this feature.
2. What is a macro virus?
Macro virus is a computer virus registered in the macro of a document or template. Once such a document is opened, the macro in it will be executed, and the macro virus will be activated, transferred to the computer and reside on the ordinary template. From then on, all automatically saved documents will be infected with this macro virus. If other users open the infected documents, the macro virus will be transferred to his computer.
If a document contains a macro virus, we call it infected with a macro virus; If the template in WORD system contains macro virus, we say that WORD system is infected with macro virus.
Although OFFICE97/Word97 can't scan macro viruses on floppy disks, hard disks or network drives (to get this protection, you need to buy and install special anti-virus software). However, when you open a document that contains macros that may carry viruses, it displays a macro warning message.
In this way, you can choose whether to include macros when opening the document. If you want the document to contain macros that you want to use (for example, a purchase order used by your company), you can include macros when you open the document.
If you don't want to include macros in the document, or you don't know the exact source of the document. For example, the document was received as an attachment to an e-mail, or it came from a network or an insecure Internet node. In this case, in order to prevent possible virus infection, when a macro warning prompt appears when opening the document, it is best to select "Cancel Macro".
After the OFFICE97 software package is installed, the system contains options about macro virus protection, and its default state is to allow the "macro virus protection" check box. If you like, you can terminate the system's examination of document macro virus. When Word displays a macro virus warning message, clear the Ask questions when opening a document containing macros or custom content check box. Or turn off macro checking: click Options on the Tools menu, click the General tab, and then clear the Macro Virus Protection check box.
However, I strongly advise you not to cancel the macro virus protection function, or you will lose this natural barrier to protect macro viruses.
Second, the macro virus judgment method
Although not all documents containing macros contain macro viruses, you can be 100% sure that there are macro viruses in your OFFICE documents or OFFICE systems in any of the following cases:
1. After the macro virus protection function is turned on, when you open the document written by yourself, the corresponding warning box will pop up. And you know that you don't use macros in it or you don't know exactly how to use macros, then you can be completely sure that your document has been infected by macro viruses.
2. In addition, when Macro Virus Protection is turned on, a series of files in the OFFICE document will issue a macro warning when they are opened. Because we seldom use macros, when you see a series of documents with macro warnings, you can be sure that there are macro viruses in these documents.
3. If you enable the macro virus protection option in the software, you will not be able to save this option at the next boot. WORD97 provides macro virus protection function, which can be set in Tools/Options/General. However, in order to cope with the macro warning function provided in OFFICE97, some macro viruses will automatically block the macro virus protection option every time they exit OFFICE after infecting the system (this is usually only possible if the macro virus protection option is turned off or "Enable Macro" is accidentally selected after a macro warning appears). Therefore, once you find that the macro virus protection function option set in your machine can't remain effective between starting WORD twice, your system must have been infected with macro virus. That is to say, infected with a series of WORD templates, especially normal.dot.
Since most people don't need or don't know how to use the function of "macro", we can draw a very important conclusion: If your OFFICE document opens and gives a macro virus warning box, then you should be highly alert to this document, and it is likely to be infected. Note: Simply deleting documents infected by macro viruses can't remove macro viruses in the OFFICE system!
Three, macro virus prevention and removal
1, the preferred method: use the latest version of antivirus software to remove macro virus. Using antivirus software is an efficient, safe and convenient cleaning method, and it is also the first choice for general computer users. However, macro virus does not have so-called "broad-spectrum" killing software as some manufacturers or careless people think, and the outstanding example in this regard is Ethan macro virus.
Ethan macro virus is quite hidden. For example, anti-virus software such as KV300 Z+, RAV V9.0( 1 1) and KILL 85.03 (which should be regarded as a relatively new version) can't be found. In addition, this macro virus can quietly cancel the macro virus protection option in WORD, and in some cases, it will set the infected document as read-only, thus saving itself better.
Therefore, dealing with macro viruses should be the same as dealing with other kinds of viruses, and try to use the latest version of anti-virus software. No matter what kind of antivirus software you use, it is very important to upgrade it in time. For example, although KV300 Z+ can't kill ETHAN macro virus, the latest KV300 Z++ can already kill it.
2. Emergency treatment method: Take wordpad or WORD 6.0 document as a bridge to remove macro virus. If your WORD system is not infected with macro virus, but you need to open a foreign document that has been found to be infected with macro virus, and the existing anti-virus software at hand can't kill it, you can try to kill macro virus in the document by opening the document containing macro virus (of course, open macro virus protection function in WORD, and choose to cancel macro when a macro warning appears), and then select from the file menu.
In the above method, saving in wordpad format is based on the fact that there are no macros in RTF document format, and saving in WORD6.0 format is based on the characteristic that a WORD97 document will lose macros when converted into WORD 6.0 format. The rtf format used by WordPad is suitable for the case that the content in the document is limited to words and pictures. If there are graphics or tables besides words and pictures in the document content, these contents will not be lost when saved in WORD6.0 format.
After saving, you should check the integrity of the document. If the contents of the document are not lost, and the macro warning no longer appears when the document is reopened, then you have completed the task.