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

See if this get you what you need

http://www.xtremevbtalk.com/showthread.php?t=290294
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Jonco" wrote:

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

John Bundy wrote:
See if this get you what you need

http://www.xtremevbtalk.com/showthread.php?t=290294

This answer didn't really answer my question. Especially concerning the
part about having the default name be "Aug 08" or whatever it needs to
be in relation to the date in the call A5.