I am using Datalink version 3.1.6 and require a VBA code for refreshing the whole sheet in every 5 seconds.
I have some current values and some archive values in the report.
I cannot upgrade to Datalink Beta version , which is having automatic refresh (update) functin inbuilt withi in.
Please help with How to use a timer in VBA?
Thanks in Advance