Excel 97 Version

Instead of my customers having to use the "Save As" function, I wa
wondering if VBA can do it for me based on cell contents? Here is wha
I want to accomplish.

I have a List Box with 0-26 numbers listed for the customer to select
number from.
The moment they select a number from the List Box, I want the progra
saved as "Week_" and then the number they selected.

I also want a message box to appear stating that the file new fil
name.

The list box is linking to cell AF33

Thanks in advance

--
Message posted from http://www.ExcelForum.com