Print Preview Excel Template with VB 2010

[RobT]

*sigh*

I can't get this to work. My program fills all the values into an Excel spreadsheet- no problems there. What I'd like to do is a print preview/print function. I can't seem to get my code right, all I get are blank pages in the print preview box.

            Dim oExcel As Object = CreateObject("Excel.Application")
            oExcel.Workbooks.Open("C:\DailyLogs\DailyLog.xlsx")
            PrintPreviewDialog1.Document = PrintDocument1
            PrintPreviewDialog1.ShowDialog()
            oExcel.Sheet1.PrintPreview()

So as I see it, this should open excel, then navigate to the actual excel file. The print preview dialog should come up, which it does, and the excel sheet 1 should be previewing, but it's not? I don't have any errors, just a blank print preview.

Does anyone have any ideas? I've been up and down the internet with no luck.

Thanks

[danp129]

If you exit the code, leaving the sheet open, does print preview look right?

If you do a print preview while recording a macro, do you see anything done in code it generates that is helpful?