Forum Discussion

Copper Contributor

Sep 21, 2021

Solved

create a script

Hello community, i have a excel file which take his data from the web. When i click on "refresh all" i get the current data. so i created a script which do that for me. But unfortunately the dat...

excel

Macros and VBA

Juliano-Petrukio
Sep 22, 2021
you can refresh all connections with this piece of code
ThisWorkbook.RefreshAll
or just your desired connection with
ActiveWorkbook.Connections("YourConnectionName").Refresh

Juliano-Petrukio

Bronze Contributor

Sep 22, 2021

you can refresh all connections with this piece of code
ThisWorkbook.RefreshAll
or just your desired connection with
ActiveWorkbook.Connections("YourConnectionName").Refresh

sway-bob
Copper Contributor
Sep 23, 2021
the excel list is also set to "auto save".
I run the script and open the file and see that the list has not updated. Should I have to extend the code and say that it has to save it?
- JKPieterse
  Silver Contributor
  Sep 23, 2021
  The script always operates on the file that you have open, so you cannot use this on a file that is not currently the active (open) file. To refresh a workbook stored on Sharepoint you can use a Flow.