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 […]
How to Unzip file using VBA – Excel Macro?
November 25, 2024
Extract Zip – Unzip files with VBA To extract Zip file content, You can use windows default “Compressed (Zipped) Folder” application. There is no inbuilt object within VBA to do this. You have to invoke the Windows Compressor using Shell object. Here is how it is done. 1. VBA Macro […]
Find Last Day of Month – Excel Formula & VBA
November 25, 2024
How to get Last day of Month? Excel has many option to find this End of Month. But in this page, We have given only the direct method. In Excel this formula can fetch you the End of month value. =EOMONTH(“2/12/2023”,0) – This will return the value as “2/28/2023”. This […]
Excel VBA – Loop thru all Keys & Items in Dictionary
November 25, 2024
Dictionary Object – Accessing all Keys & Items In this article, You can get code to access a Dictionary object key & item in a loop. There are 5 different methods to do this. Loop thru each Key by Directly accessing each key Using Index number Read each Item by […]
Excel VBA Dictionary Datatype – Create & Add Keys, Items
November 25, 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 […]
VBA – Find My Documents, Desktop & System Folder Path
November 25, 2024
VBA Code to Find My Documents Folder Path This code will get the folder path directly pointing to the ‘Documents” folder. Using this code, the documents folder path can be returned in a string variable. This technique is used when You need to save any log or temporary file in […]
VBA Wait Time – Pause Code Execution for Few Seconds
November 25, 2024
How to Make VBA to Wait for Few Seconds? Sometimes You have to make code execution to halt (vba wait time) for few minutes. This happens when VBA code has dependency on external applications like IE page load, Outlook mail download or Database query retrieval etc. So, the VBA coed […]
Excel VBA Rename File – Without opening the File – 2 Easy Ways
Get Excel VBA Rename file – Macro code to change file name. Input existing file name with itspath & new name. This VBA code will rename file to new name..
Merge Multiple Excel Files to One – Selected Sheets
November 25, 2024
How to Combine Sheets from Multiple Excel to One? This flexible Excel app in this page will merge Worksheets from multiple Excel files to one file. The User gets the option to select which files they need to be merged. Just follow these simple steps to use this app: Copy […]
Clear Excel VBA Immediate Window – Macro Code
November 25, 2024
Clear Excel VBA Immediate Window Manually There is no explicit option to clear immediate window. Just select all content in Immediate window using control + A, then press delete button. This is the only option to clear the data in this window. Excel VBA Code to Clear Immediate Window As […]