Code: Function lngHexToLong(ByVal strText As Strin

Here is a way of converting a string of hexadecimal (base 16) digit characters to a LONG numeric value.

Since this is an internal function (called by other procedures, not directly called by the user) I am allowed to make the assumption that the incoming string of hex digits is a valid string; that is, that it is an even number of characters taken from the set 0-9 and A-F.

Somewhere in between the user call (a Macro) and this procedure must be a procedure that checks that the string is valid.