Display message during data import

[dmacmillan]

Hi All,

I want to display a "Data Refreshing" message that runs for 1 minute every half-hour while data is being imported from a .CSV file. The importation has been set-up in the Data Connections tab and not driven from VBA. My investigations lead to using a combination of Application.OnTime and a Modeless UserForm.

Is this the best approach?

Thank you in advance,
David

 

[Anthony47]

That is the approach that I use, but I don't know if it is the best practice.

Of course you shall remove the property "update every 30 minutes" and instead use a vba driven refres, putting something similar to this in your "On Time" macro:

ActiveSheet.QueryTables(1).refresh

Also, rather than having the message shown for 1 minute, you shall show the modeless form with the message, start the data refresh (instruction above) and then hide the form; so it may show for 5 seconds or 2 minutes, depending on how long refreshing the data will last.
This requires that also the property "Allow background refresh" be removed (I am nor sure which is the english name for this property, look for something similar to what I wrote).

Bye

 

[dmacmillan]

Anthony,

Thank you for your input. It's all food for thought.

Kind regards,
David