Open new text file?

[PetergUK]

I have a query related to the above.

I want to do exactly as above to create a log file, but my problem is naming the file using a string made up of "backup" and the date, i.e. backup22.09.2000.txt.

I've tried:

strFileName = "backup" & Date & ".txt"

Open "C:\Temp\strFileName" For Output As #1 and


Open "C:\Temp\"strFileName"" For Output As #1

but neither work. Can you help me on the correct syntax please?

[mlewis]

Syntax:

Open "c:\temp\" & strFileName For Output As #1

Hope that helps.

[PetergUK]

Thank you for your reply mlewis. I've just tried that and i'm getting a "path not found" error. I should say i do have a C:\Temp directory... :-)

[HeSaidJoe]

PetergUK ..don't use mm.dd.yyyy
[code]
Option Explicit

Private Sub Form_Load()
Dim x
x = Format(Now, "ddmmyyyy")
x = "C:\my documents\backup\" & x & ".txt"
Open x For Output As #1
Write #1, "OK"
Close

End Sub
[code]

[PetergUK]

That's great HeSaidJoe

Can you explain why yours works and mine doesn't?

[CyberSurfer]

Because a filename usually consists of name.extension, whereas your file name would have been day.month.extension or whatever. More than one dot, you see.

[PetergUK]

Doh!!!!!!!!!!!

[HeSaidJoe]

PetergUK
[code]
'actually it has nothing to do with .
'it is just bad practice to use characters in filenames

'the reason was in your writing of the variable
'
'your statement should create a file called C:\Temp\strFileName
'and not what was stored in strFileName
'
'Open "C:\Temp\strFileName" For Output As #1 and
should be
Open "C:\Temp\" & strFileName For Output As #1
[\code]

[PetergUK]

Thanks HeSaidJoe

It was the & that got me......

[Jop]

Because a filename usually consists of name.extension, whereas your file name would have been day.month.extension or whatever. More than one dot, you see.

I don't think that's because of the dots, I think it displays dd/mm/yyyy

and you're not allowed to have /\<>~:?"|* in your filename.

[PetergUK]

Thank everyone, i've now got it working nicely:

-----------------------------------------
Dim strFileName

NetUser

strFileName = Format(Now, "dd.mm.yyyy")
strFileName = "C:\temp\backup log " & strFileName& ".txt"
Open strFileName For Output As #1

Write #1, Time & " Application opened by " & NetUser
-------------------------------------------

By the way, when writing to the txt file, what's the difference between Write and Print? The help files don't seem to make a distinction.

[Dim]

If you Write to the file then it will put whatever you write in quotes (""). But if you use Print then it will print without the quotes ("").

Hope that explains it for you,
D!m