The files from Scott's presentation on using Excel to automate users acceptance testing (UAT) are available for download.

To make things a little less confusing for people who were not at the meeting I have commented out the following code in the workbook.  For automating your tests and getting the html output you will want to uncomment the code.

Private Sub Auto_Open()
   ' ThisWorkbook.XmlMaps("Root_Map").Export ThisWorkbook.Path & "\" & Format(Date, "yyyymmdd") & "_UAT.xml", True
    'Application.DisplayAlerts = False
    'Application.Quit
End Sub