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