Document variable

Topic

New Reply

I’m reviewing some VBA code which I did not write, and I’ve seen code similar to the following:

Code:

ActiveDocument.Variables.Add “Office”, “0” Or “123”

I’m not familiar with the Or operator used when setting the value of a variable. Can anyone tell me how the Or operator functions here, and how/why a condition would be evaluated (if indeed that’s what is occurring).

Thanks.

Reply | Quote

Replies

My guess is that this is a coding error. It doesn’t make any sense to have a condition there.

Reply | Quote

Hi

I am guessing that someone has missed an apostrophe to comment out the “0” Or “123”.
Hence coding error.

I wonder if the code runs because the value component of the variables.add method is optional.

I tried this quickly

Code:

Sub test()
ActiveDocument.Variables.Add "Office", "0" Or "123"
End Sub

Sub test2()
For Each oVar In ActiveDocument.Variables
    Debug.Print oVar.Name & vbTab & oVar.Value
Next
End Sub

The printed result read Office 123

Cheers
G

Reply | Quote

The two strings would be converted to numbers, then a bitwise OR is performed. Not a lot of point if one of them is 0 though…

Reply | Quote

Thank you. I’m wondering if “123” should have been “128”, which would make sense: “0” OR “128” or “64” OR “128”. (Similarly, “0010” OR “0100”.)

Is this what you are suggesting?

Reply | Quote

No. A bitwise OR of 0 and any other number just returns that other number. There is no point to it.

Reply | Quote

Understood. I’m asking what occurs if x = 64 OR 128. Can you tell me about that?

Reply | Quote

192 according to the online calculator I used.

cheers, Paul

Reply | Quote

It’s a bitwise OR, so write the two numbers down in binary and where either (or both) of the digits is 1, the result is 1, otherwise 0. So:
01000000 = 64
10000000 = 128
———-
11000000 = 192

Reply | Quote