Forum

Calculate refresh t...
 
Notifications
Clear all

Calculate refresh time of every connection

2 Posts
2 Users
0 Reactions
135 Views
(@rafmolme)
Posts: 1
New Member
Topic starter
 

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.

 
Posted : 16/02/2023 12:26 pm
(@keebellah)
Posts: 373
Reputable Member
 

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

 
Posted : 17/02/2023 2:55 am
Share: