topic Re: OLE export EXCEL Doesn't work in Application Development and Automation Discussions

OLE export EXCEL Doesn't work

goyleo — Fri, 20 Oct 2023 15:26:25 GMT

Hi!

An ABAP program that generates Excel using OLE is working perfectly in production.

The same program (same version) in the development environment does not work. Does anyone know what I should check?

The SOLE transaction does not appear to have connection settings. I do not know what's happening.

Thanks!

Re: OLE export EXCEL Doesn't work

mamartins — Fri, 20 Oct 2023 16:49:00 GMT

The generated EXCEL file is saved on the server side or downloaded to the SAP GUI?

The location is hardcoded or perhaps defined on AL11? Does that location exists?

Re: OLE export EXCEL Doesn't work

Sandra_Rossi — Fri, 20 Oct 2023 17:11:55 GMT

First of all, make sure it's not a Windows problem: ask the same user to do the test in both DEV and PROD environments (i.e. same laptop, so same Windows software/OLE)

You should provide the details, I don't understand what means exactly "OLE export EXCEL" and "does not work".

Re: OLE export EXCEL Doesn't work

RaymondGiuseppi — Mon, 23 Oct 2023 05:22:02 GMT

Did you check behavior of transaction OLE (demo) for an user with same authorization roles in development and production?