Skip to Content
author's profile photo
Former Member

EXCEL 2007 download fails (Excel XP and 2003 OK)

When the ALV method that downloads to excel tries to get a registry value for file and path of EXCEL 2007 it fails as does the API for excel fm 'ALV_XXL_CALL'.

You then get a prompt about data being transferred to a SAP OFFICE document but this is still not displayable in the SAP INBOX ( transaction SBWP)

Any notes etc to fix this.

We do a LOT of downloading to EXCEL. This is a real showstopper in using OFFICE 2007.

Cheers

Jimbo

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • Best Answer
    Posted on Aug 06, 2007 at 10:18 PM

    Hi James,

    I saw a very similar problem recently. It was fixed by patching the SAPGUI to the latest level.

    Cheers

    Graham

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 06, 2007 at 02:38 PM

    Hi james

    we are experiencing the same problem. Tried to look for something on OSS but i think SAP is not that far.

    It still works if you dont use excel 2007 because that i tested on a different PC

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 06, 2007 at 02:59 PM

    James,

    Try to lower the default Macro security in Excel.

    Open Excel and use this menu path:

    Tools > Macro > Security...

    Then set the security to Medium or lower... and then re-try the ABAP code.

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 06, 2007 at 03:08 PM
    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 07:06 AM

    Hi James,

    i have the same problem with the export of data to excel version 2003. i don't get XXL-Listviewer for excel to export data. I have solved this problem with the installation of patch 3 for sapgui 7.10.

    Thanks guys, well done

    Michael

    Add comment
    10|10000 characters needed characters exceeded