Excel VBA Base64 HMAC SHA256 and SHA1 Encryption

VBA Base64 HMAC SHA256 and SHA1 To use this code, you need do this: Inside the VBE, Go to Tools -> References, then Select Microsoft XML, v6.0 (or whatever your latest is. This will give you access to the XML Object Library.) Test Base64 HMAC SHA256 debug.Print Base64_HMACSHA256(“abc”,”1234567890″) hgVRhIBbSkZqe+OY/0pxWfkFXqfu8zn8lNzsbxZYmLo= Base64…

How to: Put Double Quotes in a String in Excel VBA

In VBA, strings assigned to variables or properties are enclosed in double quotes “”, Sometimes you might want to place Double Quotes “” in a string in Excel VBA. For example: A1 =IF(B1=”Excel”,B1,””) In VBE, you can replace ” with “”, and then enclose the entire string¬†=IF(B1=””Excel””,B1,””””) in double quotes…

How To List All Files In Folder And Sub-folders Use Excel VBA

The following Excel VBA code can help you to list all files in folder and sub-folders into a worksheet. VBA Code Cloumn A: Directory, Cloumn B: File Name Line 49 Replace AllFiles.Add (Key & MyFileName), “” To AllFiles.Add (MyFileName), Key Line 69 Replace Sheets(“Files”).[A1].Resize(AllFiles.Count, 1) = WorksheetFunction.Transpose(AllFiles.keys) To Sheets(“Files”).[A1].Resize(AllFiles.Count, 1)…

Sort Column Data By Double Clicking Header Cell Use Excel VBA

If you want to sort the column data in ascending or descending order by double clicking on any Excel column header, you will need the following VBA code. See the screenshot: VBA code You can download the working example: Sort Column Data By Double Clicking Header. How to Use This…