Something like this :-

MyDate = Format(Date, "dd-mm-yy") ' NB. cannot use slashes
FileName = "C:\Documents and Settings\Ben Allen\My Documents\Eurotours\
" _
& "Eurotours" & " " & MyDate & ".xls"



Regards
BrianB


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!