title: Error when saving file using .ExportAsFixedFormat
body: <p>I have run a macro which generates a sheet that I want to save as a PDF.  When I run the method below, I get the error telling me my document was not saved (<code>Run=time error '-2147024773 (8007007b)': Document not saved</code>. </p>
  
  <p>I beleive it may be the filename that I am trying to give it...but unsure.  Happy to provide any further information.</p>
  
  <p>All variables are publicly declared </p>
  
  <pre><code>Public Sub toPDF()
  
      PDFName = "Pinger Report_" &amp; Format(Now, "dd/mm/yyyy hh:mm:ss")
      sumPDFSheet.Cells(5, 4).Value = Format(Now, "dd/mm/yyyy hh:mm:ss")
  
      finalPDFName = PDFPath &amp; PDFName
  
      'create borders around failed devices range on pdfsheet
          With sumPDFSheet.Range(sumPDFSheet.Cells(24, 3), sumPDFSheet.Cells(k - 1, 5)).Borders
      .LineStyle = xlContinuous
      End With
  
      'creates heading rows for each page in the pdf and centers correctly
      sumPDFSheet.PageSetup.PrintTitleRows = sumPDFSheet.Rows(1).Address
      sumPDFSheet.PageSetup.CenterVertically = False
      sumPDFSheet.PageSetup.CenterHorizontally = True
  
      'method call to format columns
      allColumns
  
      'save as pdf to correct folder with correct name
      With sumPDFSheet
          .ExportAsFixedFormat Type:=xlTypePDF, Filename:=finalPDFName, openafterpublish:=False 'ERRRORRRRRRRRRERRRR
      End With
  
  End Sub
  </code></pre>