Forum Discussion
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...
- you can refresh all connections with this piece of code
ThisWorkbook.RefreshAll
or just your desired connection with
ActiveWorkbook.Connections("YourConnectionName").Refresh
So running your script does not update the data in the workbook? What about manually updating the data, does that work?
yes, it works manually