Rename a workbook and save to another location

I've selected a cell from another sheet, now i want to select an already open workbook using this value

I have this code

Please Login or Register  to view this content.

With the problem bit in Red. What do i need to change this to, to get to work.
Note that there is another part to this that selects the vairable that i have not included


Thanks for your help

What is the current name of the workbook that you want to save?

This will save it under a new name

Please Login or Register  to view this content.

You don't need to activate a workbook to save. In my example, you could replacing newName with currentName will save the file to the new location (defined by sPath) with the currentName. (Since you are using variables, the quote marks should be removed.)