February 16, 2023
Hello, I have a Dashboard with more than 20 connections. When I refresh data for the first time in the day, it lasts more than an hour sometimes... second refresh lasts 25 min, and so on...
I was thinking to create a VBA that records the time of refreshing of every connection.
Can someone help me out with this? I have a VBA to refresh all my connections a record the time, but for some reason cant get it to refresh manually every connection and record the time of each.
October 17, 2018
You can use two cells:
When the VBA routine is triggered.
Some thing like this
worksheets(xxx)Range(whatever 1) .value = now()
the rest of your code
right before the macro quits
worksheets(xxx)Range(whatever 2) .value = now()
All you have to wo is place a formula in the line below the last one that calculates the differences between both values ans format is as time
worksheets(xxx)Range(whatever 3) .value = worksheets(xxx)Range(whatever 2) - worksheets(xxx)Range(whatever 2)
Hope this makes sense