giving name to new file

[questionit]

Hi
I am opening a file (creating new one at same time)

  LogFileName = "C:\" & "logfile" & Now() & ".txt"
 

but the above code is not good for

Open LogFileName For Append As #FileNum
 

because i am doing Now() thing with file name and path.

Therefore i get Path Not found error:

Is there any way to add current Date and time with file name when creating a new file ?

Thanks

[barry07]

The problem is that Now() by default returns the date and time in the format

dd/mm/yy hh:mm:ss

You can't have multiple colons in path names and the forward slashes are interpreted as directory separators - in this case for directories which don't exist.

Try this instead:
<code> vb
LogFileName = "C:\" & "logfile" & format(Now(),"dd-mm-yy") & ".txt"
</code>

which will create a file named C:\logfile10-08-07.txt, which is what I think you want