Member Avatar for yorro

How do I Load an excel file to the PrintPreviewDialog?

Imports Excel = Microsoft.Office.Interop.Excel
    Private Sub btnPrintPreview_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnPrintPreview.Click
        Dim xlApp As Excel.Application
        Dim xlWorkBook As Excel.Workbook


        xlApp = New Excel.ApplicationClass
        xlWorkBook = xlApp.Workbooks.Open(Application.StartupPath & "report_summary.xlsx")

        MyPrintPreviewDialog.Document = xlWorkBook
        If MyPrintPreviewDialog.ShowDialog() = DialogResult.OK Then
            xlWorkBook.Close()
            xlApp.Quit()
        End If
    End Sub

Error states that excel cannot be converted to .Document.

  • 1 Contributor
  • 2 Replies
  • 209 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by yorro
Member Avatar for yorro

I've tried searching for it on the internet and I've came up with nothing specific to my problem.

Note that I want an excel file to show onto the PrintPreviewDialog and NOT use the excel application's built in printpreview using xlWorkbook.printpreview

Member Avatar for yorro

Does any one have at least a site or a link to a tutorial of some sort relevant to my query?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.