Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

Disable popup when uploading excel files with macros

 



When we try to upload excel  files with macros to an internal table,
using FMs like ALSM_EXCEL_TO_INTERNAL_TABLE and KCD_EXCEL_OLE_TO_INT_CONVERT,
while executing the program it gives a popup to save that excel file , this blog explains to disable that popup

 For security reasons i had removed the filenames and the data in Excel file on screen shots

 When executing the program , it gives below popup

 

please follow below steps to avoid that popup

 Open Visual basic editor in the excel input file with macros

 

Click on the Visual basic editor icon


 

Double click on Thisworkbook

 

Select workbook from Dropdown

 

Select the event BeforeClose  from dropdown
 

Write ActiveWorkbook.Save in that method and close the window

 

Now execute your program and that popup will not appear

  • No labels