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
Bookmarks