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
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
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
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 […]
How to Schedule Gmail – To Send Emails Later?
Delayed Delivery Option in Gmail – Schedule Emails When running in a chronic life where forgetting becomes daily bread for the populace, it is always important to arrange things that are to get on line. One such important yet amazing tool provided by Gmail is the Gmail’s scheduling tool. This […]
VBA – Find My Documents, Desktop & System Folder Path
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
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
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 […]
How to Recall sent email in Gmail?
Recall Sent Mail in Gmail In the busy agile world everything happens so quick with no time. Mistakes also happen as quick as life. There is no time to regret in anything that individual is doing in the present society. There are some ways to escape the mistake. Similarly in […]