Forum Discussion

sway-bob's avatar
sway-bob
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...
  • Juliano-Petrukio's avatar
    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

Resources