What is my Public IP Address? There are no direct methods to get public ip address in VBA. This has to be done by using a web service using below steps: Open IE Explorer from VBA Code. Navigate to this page -> What is my Ip? Wait for page to […]
What is my IP Address?
January 11, 2025
[show_ip] This page displays the public IP address assigned to your computer. This shows the IPV4 address. To view IPV6, open command prompt & use the command ipconfig. Along with IPV6 public IP address, this command will display even the local IP address if your computer is connected to internet […]
VBA get Path to Default Temporary folder
January 11, 2025
VBA – Find Temporary Folder Path To save any intermediate data files, instead of creating a folder, You can use system default temporary folders. This way, there is less coding effort required to manage the new folders. But, to do that, You need to first find the folder path. There may […]
Excel Vba Save a Copy of Workbook with TimeStamp
January 11, 2025
Create Excel file copy with Date & Timestamp in Vba In Vba we can access files & create new files. While doing such file operations, You may have to save a data file with different names every time the macro is executed. In such cases, if the file name can […]
How to Convert Docx to PDF – VBA Save Word as PDF
Learn how to convert a docx to PDF file using different methods. Also using the VBA code save word as PDF or using the menu option of your choice.
Excel to XML Converter – Vba Code – Microsoft Dom
January 11, 2025
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
January 11, 2025
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
January 11, 2025
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?
January 11, 2025
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
January 11, 2025
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 […]