Secure FTP: Excel VBA FTP Upload / Download from web server using a Login 7 Password. Use this method to automate file transfer between FTP or a Webserver to Backup or uploading web server.
Excel VBA Text To Speech – Voice Application Activation
Install Excel VBA Text to Speech & make Excel VBA Speak, Voice messages. Activate Text to Speech(TTS – SAPI Win32 Speech API or Microsoft Speech SDK)
Excel VBA Get Username – in 6 Easy ways – using Macro
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.
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.