Hello all,
I am trying to VB a macro which will Save AS (to allow user to choose location), with the filename from Sheet P2, cell H1, in the macro enabled workbook file type.

H1 contains a date in the format DD/MM/YY, but I need the filename to be YYYY-MM-DD.

I also want it to show the value in B3 after this (text).

For example:
2012-09-18 Mr Pollard

Is this possible? I have tried load of different code from searches but done does all this combined.

Many Thanks

Luke