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...
How to disable “There’s already data here. Do you want to replace it?” warning
When you drag any cell with data and drop it on any other cell with data, you will get the warning, "There's...
Excel VBA: Limit The Number Of Times Workbooks Can Be Used
Suppose you want to send a demo file for users to check, but you don't want it to be used more than...
Excel VBA: How To Remove Document Inspector Warning Include Personal Information
You may get warning message about the Document Inspector when you want to save Excel file. Is there a script can remove...
EXCEL VBA Convert Current System Time to ISO 8601 UTC Time Stamp (with Milliseconds)
The Excel VBA NOW function is a built-in function in Excel that return the current system date and time, but not contains...
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,...
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...
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 [vb]...