If this is all done in
VBA, then yes... You should be able to create your
own popup box and write code like this:
call sDoSomeLengthyProcess
Sub sDoSomeLengthyProcess()
docmd.OpenForm "frmPleaseWait" ' Don't open it Modal
' process until you are about to issue a SaveAs
docmd.Cloase acForm, "frmPleaseWait"
objXL.SaveAs ...
End SUb
-- Dev
Quote:
> Hi, I have a module that creates some recordsets and
> creates an excel sheet based on the values (using early
> binding). The whole process takes about 60 - 90 seconds
> to run, but the user does not know it is running since it
> is all done in memory. Is there anyway to have a box that
> says something like "Please wait while transfering" that
> stays up until the "do you want to overwrite the existed
> xls file" box appears.
> Thanks,
> Andrew
Progress Box