Problem when opening excel in VB6
-
Hi, I've got a problem when I want to printpreview my excel file. Here is the code: Dim ExcelApplication As Excel.Application Set ExcelApplication = New Excel.Application ExcelApplication.Workbooks.Open App.Path & _ "\..\Factures\Facture " & _ LsBxFactures.ItemData(LsBxFactures.ListIndex) & ".xls" 'here is the problem, never pass this line ExcelApplication.ActiveWorkbook.PrintPreview False ExcelApplication.Workbooks.Close ExcelApplication.Quit Set ExcelApplication = Nothing At the problem line, nothing appear. excel is loaded in memory (seen with task manager) and VB throw an error ("waiting for component query" or something like that) when I want to do something after this I've installed SP5, but it's still the same. Can you help me ?? Jacques Bérard papejack@hotmail.com