>I'm trying to open an excel document in a form but I get only as far as specifying the object to open, I have this:
>
>oForm.addobject('oExcel','olecontrol','excel.Application')
>
>oForm.oExcel.WorkBooks.Open('c:\test.xls')
>
>oForm.oExcel.Height = THISFORM.txtContainer.height
>oForm.oExcel.Width = THISFORM.txtContainer.width
>oForm.oExcel.Top = THISFORM.txtContainer.top
>oForm.oExcel.Left = THISFORM.txtContainer.left
>
>oForm.oExcel.Visible = .t.
>oForm.Show
>
>But I still don't see the spreadsheet on the form. What am I missing?
>
>Thanks.
Roy,
You could place a spreadsheet on form and access its application (excel.application) through obj.application. ie: Drag&drop an Olecontrol control on to your form and 'create from file' using your xls.
Insertting a webbrowser control (like FFC _WebBrowser) and navigating to excel file is better.
But to be honest I never suggest neither Excel nor Word in a form.
Check Thread #
787305. Though it was for word, procedure is identical for Excel.
Cetin