Auto populate html document from excel cell

I have an excel spreadsheet containing html codes that want to auto populate and auto update an html document when an "update" button is pushed in the excel workbook. I have done something similar building a macro, but this was years ago and I cannot remember how to do it 

Ex: Update cell A1 with a new html code which then updates A1.html document.