In ACCESS, there are fifty-three basic macro operations, which can be combined into many other "macro group" operations. In use, we seldom use this or that basic macro command alone, but often arrange these commands into a group and execute them in order to complete a specific task. These commands can be realized through the event operation of the controls in the form, or they can be realized automatically during the database operation.
Event operations, such as "Click" button and "Double-click" list option, are all event operations on the control. So we often hear people say, "Click the' so-and-so' button to execute the' so-and-so macro command'", which means this.
1. What is a macro virus?
Macro, translated from the English word macro. Macro is a special function designed by Microsoft for its OFFICE software package. Software designers have designed a tool to prevent people from repeating the same actions over and over again when using software. It uses simple grammar to write common actions into macros, and can use pre-programmed macros to automatically run to complete a specific task without repeating the same actions, thus automatically completing some tasks in user documents.
Both WORD and EXCEL in OFFICE have macros. Word defines a general template (Normal.dot) for the public in advance, which contains basic macros. As soon as Word is started, the Normal.dot file will run automatically. If you repeat a task in Word, you can use a macro to automate it. Word provides two ways to create macros: macro recorder and Visual Basic editor. Macro combines a series of Word commands and instructions into one command to realize the automation of task execution. By default, Word stores macros in a common template so that all Word documents can be used. Almost all macro viruses use this function.
If you write a problematic macro and infect a common template (Normal.dot), as soon as you execute Word, the infected common template will spread to the later edited document. If another user opens an infected document, the macro virus will be transferred to his computer.
This is what we call a computer macro virus stored in a macro in a document or template.
General macro viruses have the characteristics of extremely fast spread, convenient production variation, high possibility of destruction and low compatibility of macro viruses. At present, anti-virus software can effectively prevent and eliminate macro viruses.
Second, what is a macro
Excel office software automatically integrates "VBA" advanced programming language, and the program compiled in this language is called "macro". Using VBA requires a certain programming foundation and consumes a lot of time. Therefore, most users only use the general tabulation function of Excel, and rarely use "VBA".
Programming with VBA language and integrating into Excel can customize specific and powerful Excel software (this is the highlight of Excel's powerful function). This is the audit and evaluation software provided by this website.
However, a few people may use VBA language to write virus programs that specifically destroy computer systems and integrate them into Excel, which will bring losses to computer users. In order to prevent this from happening, Excel comes with a "macro" detection function. When the Excel file being opened is found to have "macros", the user will be prompted to pay attention and let the user choose whether to enable "macros". The computer prompt language is as follows: "The x x file contains macros. ... macros may carry viruses. Canceling the macro can ensure security, but if the macro itself is secure, some functions will be lost. "
Whether macros are enabled or not depends on the source of the software. If you don't know the source of the software, don't enable it; If the source is known, it should be enabled, otherwise the functions set in the software will not be available.
The audit evaluation software provided by this website has been tested by the latest version of Kingsoft Internet Security, and there is no virus! So when you open the software, you need to enable the macro according to the prompt. Only when macros are enabled can these softwares be used normally. If you choose to disable macros in Excel or set the security of macros to High, you will not be able to use these softwares.
We have digitally signed all the software on this website called "Audit and Evaluation Software Network". If you don't want the "Macro" prompt box to appear every time you use our software, you can do this: When the "Macro" prompt box appears during software startup, you can select "Always trust the macro from here" in the prompt box, and then click "Enable Macro". In the future, when you use our software again, the "macro" prompt box will not appear.