about sp_OAMethod

• artman328

  SSC Journeyman

  Points: 80

  More actions

  August 5, 2003 at 2:28 pm

  #81363

  Hi, I have a big problem to execute some Excel Com methods by sp_OAMethod, anyone would help me?

  below is the code :

  -------

  declare @After varchar(255)

  set @Method='Application.ActiveWorkbook.Sheets("materials").Copy'

  exec @retcode=sp_OAMethod @ExcelObj, @Method,@After= 'Application.ActiveWorkbook.Sheets(1)'

  ----------

  the ErrorCode is"-2147211483"

  Description is "sp_OAMethod's usage..."

  Why?

  Thanks!

• artman328

  SSC Journeyman

  Points: 80

  More actions

  August 6, 2003 at 4:01 am

  #468766

  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

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