ExcelProgramThe storage location and publishing form are associated, and Excel programs written using VBA can be stored in two locations:
- Load a macro or the current Excel file;
- The release can also be released through a separate file or by loading macros;
- Advantages and disadvantages:
- Macro loading can be used by many files and is generally released as a general function (tool-type application;
- Macros in a file often interact with the data in the worksheet. You need to use the defined worksheet, which is suitable for specific applications, such as simulation of a professional process and a business report;
- The macro loading interface must be implemented by adding buttons to excel, while the worksheet form can be implemented by adding buttons and other controls to the workbook and making full use of the worksheet, very flexible;
- You can also take full advantage of formulas and other tools for worksheet-based programs to simplify program design.
- Another point: there is no security prompt for macro loading, while a prompt is displayed when the workbook does not have a digital signature. If the security is set to high, it is unavailable by default;
- Office applications developed by the application vsto have independent files and DLL storage locations;
