title: VBA to save worksheet with a specific name
body: <p>Hi  probably a simple answer but im new to VBA. </p>
  
  <p>I have a worksheet in a workbook.  This worksheet has a specific reference in cell A1 which changes each time its used.  It is basically an order number and formatted 03 01 15.  The next will be 03 02 15, then 03 03 15 and so on.  </p>
  
  <p>What I want to do is to use VBA to save the sheet in a new workbook in my orders folder, and for the new workbook to be called the order number.  </p>
  
  <p>I can use the record macro function to get the basic VBA to copy the sheet, open a new workbook, paste the values and close the workbook, but im struggling with getting the name right.  Each new workbook will have a different name based on the order number.  </p>
  
  <p>Any help would be appriciated.</p>