How to find Your VBA Version? The below code will get the VBA version detail using pre-compiler directives. We cannot display the value in thee variables. But it can be used inside the #IF. Then we can print the required values. Here is the code that can fetch VBA version […]
[Outlook VBA] Select Appointments/Meetings Invites in Inbox
November 25, 2024
Appointment/Meeting Invites using VBA In addition to handling Emails, MS Outlook application also handles calendar appointments & meeting invites. All these items are received in your Inbox. We could identify the difference manually by seeing the icon for each item. But to identify the difference in a VBA code, we […]
[Excel Shortcut] – Copy Only Visible Cells – Autofilter – Windows/Mac
November 25, 2024
Select & Copy Only Visible Cells in Excel In Excel, a row or column may be hidden when we use auto-filter option or manually hide them. Add an auto-filter over a column or a table & Select a valid value for the filter. This action will hide few rows which […]
Validate Email Address – VBA Code – Excel
November 25, 2024
Verify Email Address Format in VBA Code in this page will verify if a email id is in proper format. This code uses regex pattern matching. To do this, first You need to define a regular expression pattern that will match a valid email id. A email id has a […]
VBA get Path to Default Temporary folder
November 25, 2024
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
November 25, 2024
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
November 25, 2024
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 […]
Outlook Vba to Send Email with Attachments – Easy Code
November 25, 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 25, 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 & […]