title: Appending html files in VBA
body: <p>I have an Excel report with a bunch of sheets, each with a table of data.  I need to make a button that will create one html page containing the tables, one after the other.</p>
  
  <p>I don't know much about html, so my first approach was to have a macro that creates another worksheet with the tables on it, and then saves that sheet as html using ActiveWorkbook.PublishObjects.  The problem is that I don't want the column widths to be the same for all of the tables in the exported file.</p>
  
  <p>I think the solution is to set the column widths on each sheet and export the sheets to html individually, then append them all into one html file.  Is there any easy way to accomplish this, or will I need to write code to go into each html file and pick out the relevant sections?</p>