View original (French)

Excel macro for SAP update

EliotAnneSo Posted messages 22 Status Membre -  
EliotAnneSo Posted messages 22 Status Membre -
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 réponse

Réponse 1 / 1
margir4233 Posted messages 67 Registration date   Status Membre 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
EliotAnneSo Posted messages 22 Status Membre
 
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