Tagged: Excel VBA

We distribute data standard check tool v1.40_20231016, which complements the physical name-based standard check function similarly to the logical name-based standard check function and adds an option to remove and check the numeric suffix first. The previous version was v1.37. 1. Functions not implemented in data standard check tool v1.37_20230923 Data standard check tool v1.37_20230923...

In the article on how to solve the data standard check tool_v1.33 error “Not enough memory”, I explained how to bypass the insufficient memory error by setting the size of text, apps, and other items in the display settings to 100%. I couldn't find the cause of this error that occurred when setting the text scale to 125%, so I couldn't fundamentally solve it, but today...

Distribute data standard inspection tool v1.36_20230505 with an option to select whether to process blank characters as blank characters or as word separators when checking property names. This option can be used when the property name of the logical data model is written in English. 1. Requests Past data standard inspection tool v1.35_20230321 distribution...

When using the standard check function based on the physical name, “'424' runtime error has occurred. An object is required.” There may be errors in the message. Distribute the data standard inspection tool v1.35_20230321 that corrected this error. *(Reference) Last release Post: Data Standard Check Tool v1.34_20221215 Distribution 1. Development In the “Standard Check (Physical Name)” sheet, in column C (column name (physical name))...

Organize the table of contents of the description of the data standard inspection tool and upload it separately. Clicking on each table of contents will take you to that article. 1. Overview of data standard inspection tool 2. Standard inspection function and standard dictionary configuration 2.1. Standard Inspection Tool Screen Composition 2.2. Standard inspection function and option, input/output items 2.2.1. Standard check function 2.2.2. standard...

This is the appendix of the data standard inspection tool. You can check the processing of the number suffix of the property name, standard word dictionary simulation method, reference information of properties subject to standard inspection, license, and VBA code. This is a continuation of the previous article. Data standard inspection tool_3.Standard inspection results by case 4. Data standard inspection tool Attachment 4.1. property name...

The results of the data standard check are divided into cases and reviewed in detail. This is a continuation of the previous article. Data standard inspection tool_2.3.Configuration of standard data dictionary 3. Results of data standard inspection If the property name of the input data matches the standard term, if there is no standard term but some or all words are combined with standard words, non-standard words Regarding the attribute names used...

This is a continuation of the previous article. Let's take a look at the data standard dictionary configuration. Data standard inspection tool_2.1. Screen composition, 2.2. Standard inspection function 2.3. Composition of data standard dictionary Data standard dictionary is the input and standard of standard inspection. A standard dictionary consists of three categories: standard words, standard terms, and standard domains. Examine each component of the standard dictionary and its relationship. 2.3.1. data...