Results 1 to 3 of 3

Thread: insert ole object error

  1. Nov 15th, 2001, 11:49 AM #1
    pobuckley
    pobuckley is offline

    Thread Starter
    Lively Member
    Join Date
    Oct 2001
    Location
    London
    Posts
    101

    insert ole object error

    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.
    Reply With Quote Reply With Quote
  2. Nov 15th, 2001, 04:28 PM #2
    d4v3
    d4v3 is offline
    Lively Member d4v3's Avatar
    Join Date
    Nov 2001
    Location
    Leicester, UK
    Posts
    82
    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!
    Reply With Quote Reply With Quote
  3. Nov 20th, 2001, 11:56 AM #3
    Supester
    Supester is offline
    Addicted Member Supester's Avatar
    Join Date
    Nov 2001
    Location
    The Netherlands
    Posts
    220
    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!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width