I'm exporting the data I have in a report to the desktop of the user and in this particular case its 8 pages long. When I export it, it comes out in 9 separate html files...
How do I prevent that - so it comes out in one long HTML file.
Thanks in advance
How do I prevent that - so it comes out in one long HTML file.
Code:
Private Sub cmd_ExportOpen_Click()
Dim varCustNumber As String
varCustNumber = Me.txt_CustomerNumber
varWinUserName = WinUserName()
varDate = Format(Format(Date, "DDMMMYYYY"), ">")
varFileName = "Open Invoices" & " - " & varCustNumber & ".html"
varPathName = "C:\Documents and Settings\" & varWinUserName & "\Desktop\" & varFileName
DoCmd.OutputTo acOutputReport, "Open Invoices HTML", acFormatHTML, varPathName
End Sub
Thanks in advance