Get Excel VBA Get Username code for Windows current user name or file author. Different Excel macro codes to get User Id, Network User & Computer Name.
Safe Password Manager – Secure All Your Passwords
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.
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 […]
Print Screen Automation – Take Screenshot, Save to File and Attach in Excel
Excel VBA Print Screen Automation – Get FREE VBA Macro to give 1) ALT TAB, 2) Press Print screen Key, 3) save Screenshot to Image file and 4) attach to Excel.
How to Automatically pull data from Website into Excel VBA?
Get VBA to extract data from Website to Excel. With this Web scraping Excel vba code you can import HTML data of any website & then parse it using IE DOM objects. Excel Data Mining Tool with VBA Code.
Reading Process List From Task Manager
How to Import application list from Task Manager to Excel? Well, this can be done with the help of the Windows API Function from the library Kernel32. Using this we will be able to view the processes currently executing in our system and we don’t have to open the task […]
Excel VBA – Folder Operation – Exists, Create, Copy, Delete Directory
October 30, 2024
VBA code to Check folder Exists or not, Create Folder, delete folder, copy folder, move folder, create file, change current working directory & lot more.
Excel VBA Timer Event – Run Macro at Specific Time – Automatic Schedule
Learn to schedule excel macro to run at specific time. Run macro automatically at certain time & date. Adding Timer in Excel to repeatedly execute a Excel VBA Macro. It is a sophisticated method to add remainders in Excel.