Excel 2018

[kerryball]

The task is to change some of the values of the xls file and then save it automatically. However I am prompted to save and I have to od it manually. What code can I add at the end to do this. Also if I wanted to save the xls file to a different filename.

 

[arnelgp]

there is no code for xls file. either you do it manually or change the file to a macro enabled workbook.

 

[Gasman]

Should be ok with xls file. I still have some with running VBA.

save a workbook with worksheet_change vba - Google Search