Trouble Remembering Too Many Login Credentials – Password Management with Encryption This article explains some techniques on how to make your own password manager and convert it into a more secured application with some techniques. Most of us have 5 to 10 Login IDs and Passwords to be maintained including […]
Password Protect Excel 2010 & 2007
Easy method to Password Protect Excel 2010, 2007 and also Word documents in just few clicks with built in option. Also Learn different possible methods to Protect Office Documents using Inbuilt Options and VBA. Applicable To: MS Excel, Word or PowerPoint of MS Office 2007 and above.
Find Synonym for Selected Text using MS Word VBA
How do we refer Synonym for a word usually? To view synonym of a text in MS Word, We have to place the cursor on the word, then Right click to get the popup menu and Select option “Synonym”. Wouldn’t it be nice if we have a keyboard shortcut, to […]
Excel VBA – Shutdown Computer – Logoff User – Visual Basic Code
With this Excel VBA Shutdown Computer or Log off User in Windows PC. It uses Windows API call to initiate system shutdown from Excel VBA itself.
Lock System at Scheduled Time with Excel
Work Life Balance and Time Management This article explains how to Automate Locking a Windows Workstation and schedule your Tea breaks between hectic work, through Excel VBA Macro. Also, you can find a Excel App Download available at end of this page to schedule time and lock the system. Excel […]
Excel VBA – Import Data from another Workbook – 4 Easy Ways
Excel Import Data From Another Workbook – VBA Codes To pull data from an external Excel file, use on of these scenarios. Closed Excel file: Using VBA Import data with Workbook object Opened Workbook: Using VBA Read Excel file. External Reference within Worksheets. ODBC Data Import from another workbook. Excel […]
VBA Merge Text Files – Combine Data Files Into One with Excel
Get VBA Merge Text Files Excel Macro code & create your own Merge files application. Since it is Excel VBA merge files, no install is required.
Tata IPL 2022 Schedule PDF – Excel Match Time Table
Get IPL 2021 Dubai revised schedule PDF Free Download with Stadium details – IPL 14 Time Table, Online Ticket Booking, Venue details in table format. IPL Fixtures in Excel, PDF, Table, HTML format available.
Excel VBA – Get RGB Color of Cell – Change Background
Use this VBA Change Cell Color Excel macro, read Excel cell color & convert color index to RGB code. Learn how to change cell background color using VBA..
Export Outlook Emails To Excel – VBA Code – 5,700+ Free Downloads
Tips on How to Export Outlook Emails to Excel, from Menu follow these steps. Learn to AutoArchive, Export Emails from Outlook to Excel VBA with these tricks