Calling Excel OLE Methods from the Universal Work List

[SAP_WUG@acdi-cida.gc.ca]

Hi Jocelyn,

Thanks for your reply.  I think you're right by saying it's not the
workflow per say that's not working, reason why I also posted this message
to the portal forum.  I was hoping that among the workflow community maybe
someone has faced this challenge before and would share their experiences
on how to overcome this problem.

Achille Mpeta-Magenge



|---------+--------------------------->
|         |           "Dart, Jocelyn" |
|         |           <jocelyn.dart at sa|
|         |           p.com>          |
|         |           Sent by:        |
|         |           sap-wug-bounces@|
|         |           mit.edu         |
|         |                           |
|         |                           |
|         |           2006-06-06 20:58|
|         |           Please respond  |
|         |           to "SAP Workflow|
|         |           Users' Group"   |
|         |                           |
|---------+--------------------------->
  >---------------------------------------------------------------------------------------------------------------|
  |                                                                                                               |
  |        To:      "SAP Workflow Users' Group" <sap-wug at mit.edu>                                                 |
  |        cc:                                                                                                    |
  |        Subject: RE: Calling Excel OLE Methods from the Universal Work List                                    |
  >---------------------------------------------------------------------------------------------------------------|



Hi no name!

Suggest you check that you can call OLE objects in this way from the web
environment at all. There are some restrictions.  I.e. it may not be a
workflow thing - just a web/portal to OLE thing.


Regards,
Jocelyn Dart
Senior Consultant
SAP Australia Pty Ltd.
Level 1/168 Walker St.
North Sydney
NSW, 2060
Australia
T   +61 412 390 267
M   + 61 412 390 267
E   jocelyn.dart at sap.com
http://www.sap.com

The information contained in or attached to this electronic transmission
is confidential and may be legally privileged. It is intended only for
the person or entity to which it is addressed. If you are not the
intended recipient, you are hereby notified that any distribution,
copying, review, retransmission, dissemination or other use of this
electronic transmission or the information contained in it is strictly
prohibited. If you have received this electronic transmission in error,
please immediately contact the sender to arrange for the return of the
original documents.
Electronic transmission cannot be guaranteed to be secure and
accordingly, the sender does not accept liability for any such data
corruption, interception, unauthorized amendment, viruses, delays or the
consequences thereof.
Any views expressed in this electronic transmission are those of the
individual sender, except where the message states otherwise and the
sender is authorized to state them to be the views of SAP AG or any of
its subsidiaries. SAP AG, its subsidiaries, and their directors,
officers and employees make no representation nor accept any liability
for the accuracy or completeness of the views or information contained
herein. Please be aware that the furnishing of any pricing information/
business proposal herein is indicative only, is subject to change and
shall not be construed as an offer or as constituting a binding
agreement on the part of SAP AG or any of its subsidiaries to enter into
any relationship, unless otherwise expressly stated.


-----Original Message-----
From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf
Of SAP_WUG at acdi-cida.gc.ca
Sent: Wednesday, 07 June 2006 6:11 AM
To: SAP Workflow Users' Group
Subject: Calling Excel OLE Methods from the Universal Work List

Hello to all of you WUG members,

I am trying to edit an excel file from the portal (it starts as a work
item
from the Universal Work List).  I'm using the OLE interface as follows:

********************************************************
  CREATE OBJECT excel 'Excel.Application'.
  CALL METHOD OF excel 'Workbooks' = workbook.

  CALL METHOD OF workbook 'Open'
    EXPORTING
      #1 = filename.

  SET PROPERTY OF excel  'Visible' = 0.

  CONCATENATE firstname lastname INTO cons SEPARATED BY space.

  CALL METHOD OF excel 'CELLS' = cell
    EXPORTING
      #1 = 4
      #2 = 2.

  SET PROPERTY OF cell 'VALUE' = cons no flush.

//Lots of code for cell editing and then Save

  CALL METHOD OF workbook 'Save'.
  IF sy-subrc = 0.
    filename_out = filename.
  ENDIF.

//Some clean up
**************************************************

This code works perfectly when run within R/3 but from the portal I get
a
sy-subrc = 2 when calling 'Open'.  This excel file is saved on the
user's
local directory.

We are currently using EP 6, R/3 4.7 and Windows XP as the user's
frontend.

I've been able to open the document with method
cl_gui_frontend_services=>execute but I can't find any method to perform
a
cell-by-cell editing of my excel document.

Your help is very much appreciated.

_______________________________________________
SAP-WUG mailing list
SAP-WUG at mit.edu
http://mailman.mit.edu/mailman/listinfo/sap-wug

_______________________________________________
SAP-WUG mailing list
SAP-WUG at mit.edu
http://mailman.mit.edu/mailman/listinfo/sap-wug