Macro Progress Bar

[chungtinhlak]

I have a humongous macro that open queries to create and append data to table, it usually takes 3 - 4 hours to run on a good day. Is there a way to modified the progress bar to tell me which query it's running at?

[orange]

Here is a link that may be useful to a progress meter -- at least a message.
http://msdn.microsoft.com/en-us/library/aa199129%28office.10%29.aspx