When I try to insert an Excel spreadsheet ole object I get the following error:
System Error &H8007001 (-2147024895). Incorrect Function.
Does anyone know why? I use the same procedure to insert a word document and that works fine.
Printable View
When I try to insert an Excel spreadsheet ole object I get the following error:
System Error &H8007001 (-2147024895). Incorrect Function.
Does anyone know why? I use the same procedure to insert a word document and that works fine.
probably a bug in office, or your installation is corrupt. Try re-installing excel and then try! thats the only thing i can think of!
Try this:
Dim wbk As Excel.Workbook
'Of course this is the Ole object
oleXL.CreateEmbed vbNullString, "Excel.Sheet"
Set wbk = mdiMain.ActiveForm.oleXL.object
For the rest refer to the wbk.sheets.....etc.....
Have fun!;)