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...
 0 0

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...
 0 0

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...
 0 0

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...
 0 0

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...
 0 0

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,...
 2 0

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...
 0 0

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]...
 24 0