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.
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… [Continue Reading]
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… [Continue Reading]
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.
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..
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
Convert VCF To Excel – Convert contacts in VCARD to Excel with this app – Supports VCF file from Android, iPhone & Outlook & export VCF to Xls with ease. A Free Excel VBA Application Code. No installation required. Reads each contact detail from VCF file and export each to XLS format.
Get Excel VBA Create Worksheet using Sheets.Add using the macro code from this page. Learn step by step methods to add spreadsheets dynamically.
Excel Trim Not Working – Remove Unwanted Characters Is Your Excel function TRIM not able to remove non-displayable characters? A Trim function will remove only the spaces at start & end of a text. Very less people know that there are other good functions available in Excel to remove special… [Continue Reading]
2 Ways to remove #N/A Excel error in VLOOKUP, Worksheet or VBA Macro code. Fix Vlookup #n/a & Excel #n/a common errors formula. Hide n/a Excel Error.
- Games VCF Countif Record Macro Timer in Excel Task Manager print screen HTML Table Import Data Thumbnails Text to Speech TTS Candy Crush Block Apps in FaceBook C++ Programing Machine learning AI bulk email Excel VBA vba color index vba color codes Android social media Twitter Google+ Google Adsense Tips bitcoin Calendar in Excel outlook vba mass email Data Mining Excel Macro Facebook WhatsApp python Wordpress