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. |
Any assistance is much appreciated.