I don't know about the progress bar, but when I have this situation, I
put a message box in letting the user know that it will take a while.
Justin Philips Wrote:
I don't know if this is possible but I was hoping it is. I am trying
to make a loading status bar appear while my data is being saved in
access. With large queries it sometimes takes a while and I want the
user to know that it is ben exported. Does anyone know of a way to
have a status bar with the percentage complete appear while the
exporting is taking place? Does this make sense?
-Justin
--
kevindmorgan
------------------------------------------------------------------------
kevindmorgan's Profile:
http://www.excelforum.com/member.php...o&userid=32232
View this thread:
http://www.excelforum.com/showthread...hreadid=520804