Excel Archives - Page 2 of 30

VBA Userform – Escape key to Close – Unload form

November 04, 2024

Learn how to close a vba userform with escape key. Map command button to Exit or Close a Userform with Escape key.

VBA to open or save Word document Protected or Encrypted with password

November 04, 2024

Use this VBA code to password protect or unprotect the Word document while openening the file. This macro also handles readonly protection, Write protection etc., right within the code itself.

VBA Get Numbers with in a String

November 04, 2024

Kumarapush

Excel VBA code to get all digits or numbers with a string. This function extract only the numbers from with in a string text.

Convert a XML file into a Excel Sheet

November 04, 2024

Gayathri

VBA Loads a XML file into a Excel Sheet An XML file is like a simple text file but structured in a predefined format using tags. Sometimes you need to view an XML file and do calculation on the data using Excel. The code below is used to open an […]

Excel VBA Code to Checks if File Exists in Path

November 04, 2024

Gayathri

Finding an existing file & its path using Excel VBA When writing Excel VBA code that works with external files like XML or JSON, it is important that you have controls in your code to check it the file exist. If your macro (VBA program) doesn’t find a file when […]

How to remove Signature from Outlook Email using VBA code?

November 04, 2024

Kumarapush

Get the Outlook vba code to remove the signature from a email that was autoamtically created within the macro. It is usefull when you add custom signature.