11-01-2007 1:14 AM
Hi Guys,
I am having a hard time looking for the answer why the export to excel button in my alv is not working. I used 'REUSE_ALV_GRID_DISPLAY' FM for my ALV. Once I click the export to excel button. it changes the display to excel but the records are not shown (excel workbook empty). Can anyone help me regarding my problem? thanks in advance.. your help will be really appreciated. Thank you!
Regards,
Michael Nacionales
11-01-2007 1:43 AM
Hi, Michael,
Please change the security of Marco in excel of your OS. Mark the checkbox 'Trust access to visual basic project'.
Regards.
11-01-2007 1:21 AM
Hi,
What is your SAP version. have you searched OSS for the same. As this is standard functionality you will definately find some solution to this in OSS.
Regards,
Atish
11-01-2007 1:28 AM
11-01-2007 1:32 AM
Hi Michael,
Which version of SAP R/3?
You can find this in System->Status
You can search OSS notes at https://websmp207.sap-ag.de/notes
Regards,
Atish
11-01-2007 1:37 AM
hi Atishm
under sap sytem data
component version: SAP ERP Central Component 5.0
I cant open the site you gave.. I dont have a user id for that
Thanks!
Regards,
Mike
11-01-2007 1:39 AM
Hi Mike,
You are on SAP ECC 5.0
And ask your basis to help you with the user ID for that site and tell them this issue they may be able to help you on this.
Regards,
Atish
11-01-2007 1:42 AM
Hi Atish,
Thanks for the help... I will try that out.. I will update you what will happen with this issue. thanks again!
Regards,
Mike
11-01-2007 1:43 AM
Hi, Michael,
Please change the security of Marco in excel of your OS. Mark the checkbox 'Trust access to visual basic project'.
Regards.
11-01-2007 1:56 AM
hi Up,
it is now working.. I just followed your instruction. thanks for your help! cheers!
Regards,
Mike