Activate Windows 10 Dark Mode Steps to enable dark mode in Windows 10 operating system is given below: Click Windows Start (Left bottom corner Windows icon) Select ‘Settings’ gear Choose ‘Colors’ Select ‘Dark’ under ‘Choose your color’ option Pick accent color for menus & borders Click Ok Now, system will […]
2 Ways to Enable Dark Mode in Excel – Night Mode
November 28, 2024
Activate Night Mode for Excel Here is the easy method to enable dark mode in Excel & other MS Office applications. Click ‘File’ in Menu. Select ‘Account’. Choose one of this option under ‘Office Theme’ ‘Black’ – available only for Office 365 subscribers ‘Dark Gray’ – Office 2016 Click Ok […]
[Outlook VBA] Select Appointments/Meetings Invites in Inbox
November 28, 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 28, 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 28, 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 My Public IP Address
November 28, 2024
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?
November 28, 2024
[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
November 28, 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 28, 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.