Tag: function
-
VB6/VBA functions to convert binary string to Base64 string
Here are some functions to convert a binary string, to a byte array, to a Base64 string and then back to a byte array and binary string. Run tester to see it in action, enjoy. Thanks to Tim Hastings for the Base64 functions.
-
Simple Ping function VBScript
I was after a ping function that met the following constraints; Didn’t use GetObject. Didn’t display any command (cmd) prompt. Didn’t use a temporary file. Here is what I found; I was looking at a way to timeout the above ping function after 1 second using threading, but this didn’t quite make it so simple.…
-
In Excel, find the value on the last row as a function, not VBA
Here is a quick post, how to find the value of the last cell in a column. Exaample below uses Column A with the first 3 rows used for the header: =INDEX(A:A,COUNT(A:A)+3)