What is canonical VBA code?

Question

What is canonical VBA code?

Answer 1

I don’t believe that you can answer that question without some kind of context.

However, if you have an example of canonical VB.net code, or any other reference to other programming languages in which you place the question in a context that allows one to answer your question, then that would help.

I am not familiar with such a term and I not seen it used for say c++, or vb.net, or c# code that is “canonical”.

However, I don’t believe the term Canonical applies to vba, or c# or any particular programming language.

So this is perhaps like asking:

What is a flying Ford car?

Since Ford cars don’t fly, don’t have wings, then the question would not make sense.

You have to provide further context here, since I don’t believe the term can apply to VBA code unless some kind of context is given.

Usually the term Canonical in terms of computers applies to repeating data (and compression), or data that is unique in some way.

So a group of functions in VBA that are the SAME as say the JET-SQL data engine syntax might be a limited example of the term Canonical (a set of unique “common” functions exists between VBA and JET-SQL) . However I don’t think canonical is correct term and better would be “intersection” of functions in VBA and JET-SQL.

So I don’t believe the term applies to VBA code unless it means that you can write some VBA source code, but when compiled to achieve the SAME task, the compiled code is the same, and thus the unique and final representation of such code.

Regards,

Albert D. Kallal (Access MVP)

Edmonton, Alberta Canada