Continue running while msgbox displayed

[Dodge13]

Hello
I am wondering if it is possible to have code continue running while a messgebox is displayed.

I update about 4 databases, with multple macro updates in each db, and it run overnight. What I want is a messagebox to to show that each db update is completed. My current code waits for me to select ok.

Current Code is:
MsgBox ("DB1 Updated"), vbInformation

Any ideas??

THanks
Dodge13

 

[bmacr]

Create your own message box using a regular form.

 

[SydneyGeek]

You could use a log file, which would append a line for each file as it is backed up. Something like:

Function WriteLog()
    Dim hFile As Long
    Dim strFile As String
    hFile = FreeFile
    strFile = "C:\Documents and Settings\Denis\My Documents\TestLog.txt"
    
    Open strFile For Append Access Write As hFile
    Write #hFile, "File Backed Up", CurrentProject.path, "Backup Time", Now
    Close hFile
    
End Function

Note: You'll need to create the file first, in the desired directory. Set the paths to suit.
Denis

 

[tails]

would it be possible to just set a timer in the code so that as soon as the timer runs out it goes to the next line of code, could work, not sure. never had this problem before.