Macro/VBA. Copying data from an old file, Pasting in new template, and saving as the old name.

[oosag23]

Directory C:/dbasexls start with first file 16h0001-JR.xls

unprotect the worksheet using password '<BHF>'

copy and paste e90:m387 from the .xls file to the .xlsx

file hospitalCR_FY11_Rev0117_macro disabled.xlsx in

Directory C:/dbasexlsx

return cursor to ctrl home

protect the worksheet using password '<BHF>' and

save the file as 16h0001-JR.xlsx (a macro free file)

close the file 16h0001-JR.xls and

repeat with the next file in C:dbasexls 16h1001.xls

The goal is to copy and paste e90:m387 from the old .xls file

to the template hospitalCR_11_Rev0117_macro disabled.xlsx file

and to save the template file as the same name as the old file,

but with the extension .xlsx. Repeat this for all FY16 and 17 .xls files.

<tbody> </tbody>

Any assistance is much appreciated.