I would agree with your conclusion, so maybe try

sDate = Format(Date, "ymmdd")
sDate = Right(sDate,Len(sDate-1))
..WRQReceiveFile "", "YYC" & sDate, rcASCII, rcAskUser



--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"PaulW" wrote in message
...
From that I changed
.WRQReceiveFile "", "ZZ060523", rcASCII, rcAskUser
to
.WRQReceiveFile "", "ZZ" & Format(Date, "yymmdd"), rcASCII, rcAskUser

And this worked perfectly! Cheers. Unfortunatly, it goes wrong on
.WRQReceiveFile "", "YYC" & Format(Date, "ymmdd"), rcASCII, rcAskUser

From which I guess it doesn't like the Y only being 1 digit, and thats
only
a guess.

My other problem seems to be that the macro I recorded seems to not have
made a note where these files are to be transfered to, so they're going to
the default folder, rather than where I want them. Will have to check the
settings for that :p

"Bob Phillips" wrote:

Do you mean something like

sFile = "ZZ" & Format(Date,"yymmdd")