View original (French)

Excel macro for SAP update

EliotAnneSo Posted messages 22 Status Member -  
EliotAnneSo Posted messages 22 Status Member -
Hello,

I have extracted data from SAP into Excel, and it's a table that aggregates the current orders (unbilled).
To get the table, I have to redo the extraction every week.

Is there a macro that would allow me to have the table automatically updated?

Thank you for your help! :)

1 answer

  1.
    margir4233 Posted messages 67 Registration date   Status Member Last intervention  
     
    Hello
    Do you know Power Query?
    It's an Excel add-in
    You can create a folder, put your SAP files in it every week
    Then with your Power Query that you create the first time, you will fetch all the files from the folder.
    0
    1. EliotAnneSo Posted messages 22 Status Member
       
      Hi! :)

      I don't know it at all, but it's really not what I'm looking for; I just need a "button" next to my Excel table that I can click to automatically update the table with the data that has been entered in the meantime...
      0