Find Constant Name

Find Constant Name

Instead of trapping an Error by its value (If err.number=429 then…) I would prefer to use a VB defined Constant Name.I can’t seem to find a way to locate them, if they exist.

As far as I know, there only a few constants defined for error numbers. If you need such a file, you could build one using this code:

Sub Main   Dim i As Integer   For i = 1 To 9999      If Error$(i) <> "Application-defined or object-defined error" Then         Debug.Print "Const " & UCase(Replace(Left(Error$(i), 40), " ", "_")) & " = " & i      End If   Next iEnd Sub

This will actually create constants that are named basically the same as the error messages. You can easily modify this code to write to a file, as well. Any spaces in the message will be converted to underscores, and the length of the constant will be limited to 40 characters. If you don’t have the Replace function, you’ll have to do that manually?check the archive for code that works the same as the VB 6 Replace function.

Share the Post:
Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular

XDR solutions

The Benefits of Using XDR Solutions

Cybercriminals constantly adapt their strategies, developing newer, more powerful, and intelligent ways to attack your network. Since security professionals must innovate as well, more conventional endpoint detection solutions have evolved

AI is revolutionizing fraud detection

How AI is Revolutionizing Fraud Detection

Artificial intelligence – commonly known as AI – means a form of technology with multiple uses. As a result, it has become extremely valuable to a number of businesses across

AI innovation

Companies Leading AI Innovation in 2023

Artificial intelligence (AI) has been transforming industries and revolutionizing business operations. AI’s potential to enhance efficiency and productivity has become crucial to many businesses. As we move into 2023, several

data fivetran pricing

Fivetran Pricing Explained

One of the biggest trends of the 21st century is the massive surge in analytics. Analytics is the process of utilizing data to drive future decision-making. With so much of

kubernetes logging

Kubernetes Logging: What You Need to Know

Kubernetes from Google is one of the most popular open-source and free container management solutions made to make managing and deploying applications easier. It has a solid architecture that makes