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 […]
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 […]
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 […]