Forum

VBA TEXT OUTPUT FIL...
 
Notifications
Clear all

VBA TEXT OUTPUT FILE NAME

2 Posts
2 Users
0 Reactions
218 Views
(@mr-motha)
Posts: 7
Active Member
Topic starter
 

Good day All,

How do I change the output file name to time in this format "hh-mm-ss" as the lone currently being used keeps overwriting.

 

Open LOutputPath & "" & "FileName.txt" For Output As #1

 
Posted : 05/12/2018 5:12 am
(@debaser)
Posts: 838
Member Moderator
 

Like this:

Open LOutputPath & "" & format(now, "hh-mm-ss"".txt""") For Output As #1

 
Posted : 05/12/2018 8:29 am
Share: