I've never used the GetSaveAsFileName dialogue, but that's exactly what the documentation says about it: "Displays the standard Save As dialog box and gets a file name from the user without actually saving any files."

I suppose the next step would be to take the name collected from the dialogue call—that's varResult—and use it in workbook.SaveAs.

How do I actually do that? Can you help me?

Just add
ThisWorkbook.SaveAs (varResult)

You were doing great on post #8

Like This, Wish I new more about writing code, I don't know where to put the line to make it work:

Gbaker, Ribbons had the right form. But maybe this is a good time to help you know more about writing code, if you want to take the time for it.

The statement you suggested......would take the value of varResult and put it in another variable named SaveAs—in this case a variable that belongs to an object named ThisWorkbook. But SaveAs isn't a variable (or "property") of ThisWorkbook, it's something called a "method", ie it does something. So it's as though "ThisWorkbook.SaveAs" is a command, and "varResult" is the argument you supply to tell it how to carry out that command. In this case, SaveAs is a command to save ThisWorkbook under a new name, and varResult contains the name to be used.

So how do you know when something is a property and when it's a method? Sometimes it's obvious; but when it isn't, you have to look it up in the documentation. Do you know where the VBA/Excel documentation is? Because if you don't, it's well worth knowing. I can give you some pointers for looking through it, if you need them.

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!!!

"I can't take the time to know how; I just want it to work!"

But don't give up on the forum yet; Ribbons was helping you, maybe she still will.