On Jun 18, 8:26*pm, Joel wrote:
What was wrong with the code on Friday?

see posting:http://www.microsoft.com/office/comm....mspx?author=b...



" wrote:
I posted a similiar problem with mixed success.
I am trying to write vba code to update all workbooks in a folder with
a new month & year and give them a new name and save them in a new
folder. *I need it to:
1. *Open all workbooks in a folder (c:/Month) *(there are 30 with the
file names of name1, name2, name3 etc). *There are 32 sheets in each
folder. *On sheet 1, cell S1 is the month and cell T1 is the year.
2. Unprotect sheet 1 on every workbook to allow the month and year to
change. *The password is "top"
3. Have an input box that prompts for new month (ie. mmm) once
4. Have an input box that prompts for new year (ie. yy) once
5. The contents of these input boxes need to be entered once only and
apply to every workbook in the folder.
6. Reprotect sheet 1 in all workbooks with the password "top".
7. Input box that asks for name of new folder. *Create a new folder
off c drive (eg. *c:/new)
8. Save all files in new folder as name1MonYr, name2MonYr, name3MonYr
etc to name30MonYr.
The original workbooks should remain unchanged in the folder Month.
Thank you- Hide quoted text -

- Show quoted text -

Hi Joel,
Re code on Friday, the main problem is that I need to enter the month
and year for each workbook and it does not save each one. it only
saves one file as MonYr. I will study vba code more and see if I can
figure it out and modify it as my needs change. Thanks
Bob