Get VBA Code to Convert Excel to Xml Vba code in this page reads table data by each row and adds it to Xml dom element. Once all the cell values are added, it is then saved as Xml file. With this code you can also add Namespace to the […]
How to Zip File or Folder using VBA Code – Excel Macro?
November 28, 2024
VBA Code to Zip File or Folder Just like this Unzip vba code, this also uses the Windows default file compressor. There is only one difference between this code and Unzip. Yuo just have to swap the parameters & Create a empty Zip file at first. Zip file path & […]
Find Local IP Address – VBA Macro Code
November 28, 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 […]
How to Unzip file using VBA – Excel Macro?
November 28, 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 […]
Excel VBA – Loop thru all Keys & Items in Dictionary
November 28, 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 28, 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 28, 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 28, 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 28, 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 […]