Log In
Register
Home
New Member
February 16, 2023
Offline
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.
Thanks.
October 17, 2018
Offline
Hi Esteban,
You can use two cells:
When the VBA routine is triggered.
Some thing like this
Your macro
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
1 Guest(s)
