very simple question

[altaratz]

For some reason, I can't figure this out.

I'm trying to create a subroutine that will create a text file everyday named by that day's date. Seems really simple - but after I create a variable that is equal to Now - I don't know how to get that into the Open Filename statement:

Dim date1 As String
date1 = Now
Open "c:\date1.txt" For Output As #1

Obviously - this now creates a file called date1.txt - not a file called 06-29-2005.txt, for instance

Please help

-- Ethan

 

[azrobert]

try something along the lines of


DateVar = Now
InputFileName = "C:/" & DateVar & ".Txt"
Open InputFileName For output As #1