In a cell I have a date, such as 9/1/08. Lets call this cell A5.
What I want to do is come up with the code to open a SAVE AS box and
prepare to save the worksheet with the default name of the previous
month and year, in this case it would be "Aug 08". The user could
accept this or change it if he needed to.
Another example would be the date in A5 would be 10/5/08 would open the
SAVE AS box and have "Sep 08" as the suggested or default name... ready
to save.
Thanks for any help you can give.
Jonco