Output File Overwrite problem

[klornpallier]

Hi, I have the code to save a filename to a log file as below:
FilenameA = "C:\ArchivedMails.log"
Open FilenameA For Output As #1

Print #1, FileName

Close #1

This works fine but within the file I want to add new filenames each time the code is run. At present it is overwriting the file.

 

[Remou]

Hi
If you want a new file each time, how about (?):
FilenameA= "c:\AM" & Format(Time, "hhmmss") & ".log"

 

[PHV]

And what about this ?
Open FilenameA For Append As #1

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244