How to Click Hyperlink in Excel with VBA Macro? There are 2 methods available to click a hyperlink in Excel. Both the methods do open the URL in the default browser or open the corresponding file in the default application. Here is the code demonstrates both methods. Sub follow_hyperlink() ‘Follow […]
Excel VBA Count #N/A Errors
November 27, 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 […]
Excel VBA Delete all #N/A
November 27, 2024
VBA code to delete all #N/A error in Excel #N/A error can occur as a return code from any Excel formula like Vlookup, Lookup etc., If you copy paste data only from a worksheet that has formula, then this #N/A error will occur as a string value. You can remove […]
Get list of Folders in directory path – Python
November 27, 2024
Print Directory List in Python To get list of sub-directories present in a computer folder, use the code below. Edit the folder path mentioned in the variable “folder_path”. Then execute this ready to use code. It will print the sub-directories name one by one. #List all subdirectories in a folder […]
Hyperlinks Index – Get all links with address, cell – Whole Workbook
November 27, 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
November 27, 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
November 27, 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
November 27, 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. […]
Add Time Stamp to Notepad Text File
November 27, 2024
How to add Date Time stamp in Notepad File There are 2 ways to do this. First one is manual & the other is automatic. 1. Press F5 will insert current date & time 2. Type .LOG as first line of notepad file. (case-sensitive) What is the difference between these […]
Excel VBA Get File Extension – 2 Simple Methods
November 27, 2024
Using Excel VBA get File extension from file name using this simple macro code. The code extracts the File extension using VBA File system object.