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 […]
Citizenship (Amendment) Act 2019 – CAA document link
November 27, 2024
Citizenship Act & CAA 2019 This article does not present any views about the latest Amendment to Citizenship Act 1955. But we have provided the links where the PDF version of these 2 Acts can be found. (CAA -5 Page + CA-15 Page) There is a huge nationwide stir due […]
Outlook Vba to Send Email with Attachments – Easy Code
November 27, 2024
Get Outlook VBA to send email with attachment automatically. Use this code to send automatic emails from Outlook programatically.
How to Zip File or Folder using VBA Code – Excel Macro?
November 27, 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 27, 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 27, 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 27, 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 27, 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 27, 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 27, 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 […]