i need macro which will show, display, get report about how much it took to refresh data from data source.
my company made up some file in Excel format wich can be refresh by connecting to some kind of Datasource (using password and username).
Since it takes some time to refresh data - from 1 h (in January each year) to 2-3 hours (in December), i realy need VBA code which will show exact time how much it takes to refresh data for my boss.
Any idea which macro to assign for this problem?
thx
my company made up some file in Excel format wich can be refresh by connecting to some kind of Datasource (using password and username).
Since it takes some time to refresh data - from 1 h (in January each year) to 2-3 hours (in December), i realy need VBA code which will show exact time how much it takes to refresh data for my boss.
Any idea which macro to assign for this problem?
thx
