10-18-2012, 06:33 PM
(This post was last modified: 10-18-2012, 06:34 PM by harishshenoy.)
Hi ,
While creating a HTML file why cant you use 'now()' property to give unique name to the file.
like :
and then use it in the file creation
Thanks,
Harish
While creating a HTML file why cant you use 'now()' property to give unique name to the file.
like :
Code:
FileName = "D:\HtmlReport_" & replace(replace(replace(now() , "/" , "_") , ":" , "_") , " " , "_") & ".html"
Code:
Set objFS_TestSet = CreateObject("Scripting.FileSystemObject")
Set objReport_Set = objFS_TestSet.OpenTextFile(FileName, 2, True)
Thanks,
Harish