title: Inserting a module into a new workbook using VBA
body: <p>I've had a trawl around the net and can't seem to find a simple solution to this one so hopeing you can help.</p>
  <p>I have a Macro at the moment which takes data from a .txt file and overwrites an excel file with the latest data every 3 minutes. It names the new file using the date and time of the overwrite.</p>
  <p>What i would like is for the workbook with the 'create new workbook' macro to also add a new module into each new workbook as it is created, including a pre-written macro inside the module (The inserted module will include code to record who and when the workbook is opened and closed by so will be writing into a third workbook, but i can do that bit)</p>
  <p>I'm hoping that all of this can be done with a second Sub!</p>