Forum Discussion
sway-bob
Sep 21, 2021Copper Contributor
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...
- Sep 22, 2021you can refresh all connections with this piece of code
ThisWorkbook.RefreshAll
or just your desired connection with
ActiveWorkbook.Connections("YourConnectionName").Refresh
mtarler
Sep 22, 2021Silver Contributor
maybe add a calculate operation?
workbook.getWorksheet(1).calculate
workbook.getWorksheet(1).calculate