I have a number of data reports that when exported loose their formating (boxes and lines). I know that if these reports are exported into .pdf format this will work.
I am using the following code, which works but does not create .pdf files in the correct format:
strTemplate = "MyCompany Daily Report" & vbCrLf & rptTagBody
' Add an ExportFormat object. The FileFormatString determines
' what will be displayed in the Export dialog box.
FileFormatString:="Standard Report (*.pdf)", _
The problem I have is what is the correct FormatType so as the reports open in Adobe reader?