Forum Replies Created

Viewing post 1 (of 2 total)

  • RE: about sp_OAMethod

    It's done!

    Code like this 🙂

    -------------------

    declare @before int, @after int, @oSheet1 int, @oSheet2 int

    EXEC @retcode=sp_OAGetProperty @ExcelObj, 'Sheets.Item("sheet1")', @oSheet1 OUTPUT

    EXEC @retcode=sp_OAGetProperty @ExcelObj, 'Sheets.Item("sheet2")', @oSheet2 OUTPUT

    set @Method='Copy'

    exec @retcode=sp_OAMethod @oSheet2, @Method, null, @before=null,@after=@oSheet1

    -------------------------------

    ...

Viewing post 1 (of 2 total)