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,
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