>I have an OLE object (called oleExcel) on my form that displays a chart (oleExcel.Class = Excel.Chart.5). A common dialog box (dlgSave) is also present. I use the following code to save the workbook:
>
>Set mobjBook = oleExcel.object.Parent
>dlgSave.ShowSave
>mobjBook.SaveCopyAs dlgSave.filename
>
>This works wonderfully. However, two strange things happen:
>
>1) when I launch Excel and open the saved workbook, it is always hidden. It doesn't matter if the VB app is still running or not.
>
>2) when I do 1) while my app is still running and the form is still open, a second hidden workbook is shown as open (e.g. "Book 1"). If I open that second workbook, the chart that appears on my VB form suddenly grows and becomes only partially visible in the OLE object.
Couple of questions:
1. Is there a way to flip a visible flag manually that might be defaulting to invisible?
2. Does it do this when you work with just a worksheet rather than a chart?
Jay Shepherd