Thanks Bob,
I would appreciate any pointers you could give me. For now I need to make this work. I've gone through 22 post and still can't get the code I need. I don't have enough knowledge in writing script to be able to complete this task.
All I'm simply trying to do is develop a code that will take the existing Workbook and Save it to a directory on my network and be able to rename the workbook so the original doesn't change.
I'll try another forum for now and see if someone can help me write the code. I'll get back to you when I have time to learn more about it.
Thanks for all your help!!!