issues with coding problem

I am trying to save this file but I'm having problems with "my Name" This information is in a workbook that is already opened called "Recaps" and the sheetname is "Data" and the value I am looking for is in "$C$5". I open another workbook called "Spare" and want to rename and save it to the code below.

How can I correct this error?

Please Login or Register  to view this content.

this did not work, any other suggestions?

Thanks in advance

Hi,

Does the following help ...

Please Login or Register  to view this content.

HTH
Carim