Do you mean something like

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"PaulW" wrote in message
...
I've had a search on the internet, and can't find anywhere to ask this, so
thought I'd give it a shot here.

I'm using WRQ Reflection for HP, V12
This uses VBA in a similar manner to Excel, and I've set up a macro to
transfer across certain files. Unfortunatly, some of these files are based
on
today's date, ZZ060524 for example will be ZZ060525 tomorrow. I have no
idea
how to set up a variable... in Excel it was easy enough to work it all out
in
a cell or two, and tell the macro to look at that cell, but since
Reflection
has no cells to work stuff out (as far as I know) i'm stumped.

Can anyone help, or at the very least point me somewhere were I might get
help. Cheers