excel - BitAnd and BirOr VBA function for signed 32 bits numbers

Question

I am writing a VBA routine to communicate with a PLC using DDE Poke/Request. I am trying to do Bitwise AND/OR operations on some numbers that are 32 bits and signed.

I am using WorksheetFunction.Bitor and WorksheetFunction.Bitand however, they only work for positive and less than 10 bits numbers. Do you have a replacement to these functions to suggest me?

question from:https://stackoverflow.com/questions/65849468/bitand-and-biror-vba-function-for-signed-32-bits-numbers

Answer 1

Waitting for answers