What does the # mean in the front of a statement?

[twgonder]

I'm running into more and more code samples that look something like this:

#Const Access_EarlyBind = True
#If Access_EarlyBind = True Then
    Private pAccess                As Access.Application
#Else
    Private pAccess                As Object
#End If

But I have no idea what the "#" is supposed to do. I haven't seen it documented or given a name so I can search for an explanation.


What does it mean or do?

[Welshgasman]

https://www.google.com/search?q=acce...t=gws-wiz-serp

And if you ask ChatGPT, see the picture. :-) rofl.

[twgonder]

So the answer is, it's a thing called Conditional Compiling:
Understanding conditional compilation (VBA) | Microsoft Learn

[Welshgasman]

So the answer is, it's a thing called Conditional Compiling:
Understanding conditional compilation (VBA) | Microsoft Learn

Correct. As in your example, whether you wish to enable early or late binding.

[isladogs]

ChatGPT is wrong.

A '#' cannot be used at the start of a line to denote a comment. If you try to do so, the line will be marked as incorrect syntax in RED.
Only apostrophes can be used for this purpose as in the example it gave

It IS used for conditional compilation and as here for specifying early/late binding

'#Const EarlyBind = True     'Use Early Binding
#Const EarlyBind = False    'Use Late Binding

[Welshgasman]

I did not know you could tell it that is was wrong.
I knew it was wrong which is why I was rofl.

[Amicron]

GPT is often wrong. Always double check what it tells you.

[CJ_London]

did not know you could tell it that is was wrong

if you tell it the solution it remembers, at least in the context of the sane conversation.

i was doing some investigation of addressof and it provided examples where the target sub was in the class module. When I told it the sub had to be in a standard module it apologised and provided a correct example, and continues to do so.

[Welshgasman]

So what if you were to tell it something that was also wrong?

[CJ_London]

I’m never wrong, just misunderstood 😁😁😁

[isladogs]

I've deliberately asked it questions I know the answer to and it gets them wrong about 75% of the time.
As stated, it will take into account any corrections it is given but will often still make more mistakes

I've also deliberately fed it incorrect information which it also accepted.
In my opinion Chat GPT is better at analysing than it is at providing correct code

Perhaps it should use a strapline like mine (see below)!