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 […]
Find Last Day of Month – Excel Formula & VBA
November 21, 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 […]
VBA Wait Time – Pause Code Execution for Few Seconds
November 21, 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 […]
Get Current Date in Vba
November 21, 2024
Display Today’s Date & Time in VBA Function used to displaz the current date / time is Vba.Now() This function will return the date & time in this default format: 7/14/2029 11:34:31 AM The returned output can be formatted into any desired format as given in the below code snippet. […]
Add Time Stamp to Notepad Text File
November 21, 2024
How to add Date Time stamp in Notepad File There are 2 ways to do this. First one is manual & the other is automatic. 1. Press F5 will insert current date & time 2. Type .LOG as first line of notepad file. (case-sensitive) What is the difference between these […]
Excel vba Add Date Time Stamp to File Name
November 21, 2024
Save File with Date Time Stamp In Excel vba we can create new file or save the current workbook with different name. In that case, sometimes we add date, time or both at end of file. This way, the file names will be unique & also the file versioning can […]
Printable 2022 Calendar Excel – Month Wise Template
November 21, 2024
Get Printable 2022 Calendar Excel Template. Take Calendar print out and stick to your desk for quick reference. Easy to print Excel Month wise Calendar Template.
Convert Excel String To Date – VBA Date Format
Use this simple technique that converts Excel string to date using menu option & VBA code. Use VBA string to date conversion code in Excel automation.