Excel VBA: Copy and Paste a Range

One of the most common action you’ll need to learn is copying and pasting a range of data. It’s very easy to do this manually. In normal data, we use either CTRL + C to copy a selection of data and then use CTRL + V to paste the selected…

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)…