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 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 […]
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 […]
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. […]
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 […]
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 […]
Get Yearly Calendar Template in Excel. Take Calendar print out and stick to your desk for quick reference. Easy to print Excel Month wise Calendar Template.