This video helped me a lot. I will try it out. Thanks 👍👍
@ERP-UP3 ай бұрын
Great 👍
@ERP-UP3 ай бұрын
Export SAP data into multiple Excel files
@yuri23653 ай бұрын
A Ferrari advice!!!
@ERP-UP3 ай бұрын
Thank you so much Yuri
@kamila67013 ай бұрын
Thank you, great material. And maybe you know how to make saved files (.xlsx) not open automatically after saving the file ?
@ERP-UP3 ай бұрын
Thank you. The excel file is automatically opened because of the SAP export. You can close the excel file afterwards using the Workbook.Close method in VBA. If you want to export the SAP data in background I recommend to use ABAP. Therefore you can use ABAP2XLSX: kzfaq.info/get/bejne/m7dgmq2r1czaopc.htmlfeature=shared
@howtolearnexcel8 күн бұрын
Awesome channel and content! Do you know if there is a possibility to disallow auto-opening these Excel files? I've seen a few VBA workarounds with Win Shell. But is there a better native solution?
@ERP-UP4 күн бұрын
Thank you so much. Highly appreciated. The excel file is automatically opened because of the SAP export. You can close the excel file afterwards using the Workbook.Close method in VBA or with Win Shell. If you want to export the SAP data in background I recommend to use ABAP. Therefore you can use ABAP2XLSX: kzfaq.info/get/bejne/m7dgmq2r1czaopc.htmlfeature=shared
@howtolearnexcel3 күн бұрын
@@ERP-UP Thank you. Gonna try the WinShell approach.