title: Excel VBA to Save As with "." (period) in File Name
body: <p>I have a macro in excel 2013 that autofills the file name in the Save As dialog box with the value of cell C20. However when the name contains a period such as "ABC_12.1_2017" the file name field in the Save As dialog box is blank. If I remove the period(s) the correct name appears. </p>
  
  <p>It seems that this exact problem was solved in <a href="http://www.excelforum.com/excel-programming-vba-macros/999024-save-file-as-pdf-with-period-in-file-name.html" rel="nofollow noreferrer">this forum</a>, but I read through the solution and can't understand what was changed. Any insight would be appreciated.</p>
  
  <pre><code>Sub SaveAsNew()
  'opens save as with the filename prefilled by value of c20 and hides the copy template sheet
          ActiveSheet.Visible = xlSheetVeryHidden
          Application.Dialogs(xlDialogSaveAs).Show Sheets("Copy Template").Range("c20")
  End Sub
  </code></pre>