How to Initialize an Array in Vba? Different methods to assign values to array are explained here. Starting from basic to few easy methods to initialize array with multiple values are discussed in here. Here are the list of available methods. Direct or a loop method. Using VBA function Array. […]
[Outlook VBA] Select Appointments/Meetings Invites in Inbox
December 22, 2024
Appointment/Meeting Invites using VBA In addition to handling Emails, MS Outlook application also handles calendar appointments & meeting invites. All these items are received in your Inbox. We could identify the difference manually by seeing the icon for each item. But to identify the difference in a VBA code, we […]
Outlook Vba to Send Email with Attachments – Easy Code
December 22, 2024
Get Outlook VBA to send email with attachment automatically. Use this code to send automatic emails from Outlook programatically.
Find Local IP Address – VBA Macro Code
December 22, 2024
Computer IP Address – Local & Public IP stand for Internet Protocol address. It is assigned to every network device – be in a computer, smartphone, router etc., This address is used to send the Internet data packets to the correct device attached to internet. The IP address have different […]
Excel VBA Dictionary Datatype – Create & Add Keys, Items
December 22, 2024
Excel VBA Scripting.Dictionary “Dictionary” is a datatype similar to an array, but in addition it can hold a group of variable or objects. Another available data type similar to this is “Collection”. In short it can be called as an Indexed Array. You have to include a reference to “Microsoft […]
Excel VBA Count #N/A Errors
December 22, 2024
How to count number of #N/A error in Excel? Number of occurrence of #N/A error in a column can be found by using the formula: Countif(<column>,”#N/A”) Consider, You havefew vlookup formula in column D. Out of it, few resulted in #N/A error. To get the count of this error in […]
Hyperlinks Index – Get all links with address, cell – Whole Workbook
December 22, 2024
Get list of all Hyperlinks in Excel file This macro produces a hyperlink index sheet. To get list of hyperlinks in each worksheet, the Vba code in this page follow these steps. Add a new sheet for Output Loop through each Worksheet Loop thru each hyperlink Get hyperlink address, path, […]
List all windows UserNames & Domain in VBA
December 22, 2024
List all User Accounts in Windows using VBA In vba use this code to get windows user account names & their domain names. Copy paste this code into your Excel vba project module. Run the code by pressing F5. You will get a complete list of use account names and […]
Vba Get Computer Name using environment variable
December 22, 2024
Find Computer Name in Excel VBA In this page, get three different vba code to get Computer name. Environment variable Windows Api wScript.Network To get the computer name or the host name there can be more multiple ways. But, one of these could serve the purpose. 1. Get Computer name […]
Get Current Date in Vba
December 22, 2024
Display Today’s Date & Time in VBA Function used to displaz the current date / time is Vba.Now() This function will return the date & time in this default format: 7/14/2029 11:34:31 AM The returned output can be formatted into any desired format as given in the below code snippet. […]