How to replace #N/A in Excel with 0 or blank values using formula. Usually a formula like Vlookup returns such errors & this Excel function can handle this.
Get Outlook vba code to sort emamils by date in the inbox or in any folder. This code can sort the emails by oldest first/newest firlst as per your choice.
Learn VBA to unhide all sheets in a Excel workbook. This code sets visibility property of sheet to unhide even the very hidden sheets.
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 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 […]
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 […]